{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Start Here","Network","IOM Device","IOM Device - Energy Meter","SZ - Smart Equipment","SZ - 3rd Party Equipment","MZ- Zone Coordinator","MZ- Smart Equipment","MZ- 3rd Party Units","MZ- VAV Zones","MZ - COBP Zones","MZ- Bypass Damper","Adv. Application Controller","Fan Coil Units","Lighting","BOM","Pricing","Learning Videos","Smart Building Hub Videos","VAC100x Controllers Videos","Energy Meters","AOMS List Price","Source 1 Parts Ref"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start Here","index":0,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,1,5,15],[35,22,35,26]]}
[]
[]
[]
[]
[null,"How to use selection pages."]
[null,"Selection Pages is setup to estimate a single Verasys Job.  This sheet is intended to be used by customers that will procure the product through JCI's order management system in AOMS or UST.  Click the \"Start\" Button and complete each page as needed until you reach the final \"Bill of Materials\" (BOM) page.  The BOM page will list out all selected products; once filtered to remove the zero quantities it can be faxed or emailed to place the order.  \n\nIf you have any application questions or selection assitance please contact call the Verasys Hotline at 1-866-663-6105, Mon-Fri 8am - 4pm CST"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Released 05/18/18- Version 32 UPG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonelli"]

{"sheet":"Network","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[7,1,7,2],[4,1,5,7],[15,1,15,2],[11,1,11,2]]}
[]
[]
[]
[]
[null,"Verasys Network Selection Page"]
[]
[]
[null,"Smart Building Hub"]
[null,"JCI Part Numbers","Required for all new sites!",null,null,"Qty"]
[null,"LC-SBH200-0","Verasys Smart Building Hub",null,null,0]
[]
[null,"Smart Building Hub Accessories",null,null,null,"Qty"]
[null,"ACC-PWRKIT-1A24","Verasys LC-SBH200-0 Power Supply (Recommended!)",null,null,0]
[null,"ACC-WIFIKIT-0DU","Verasys LC-SBH200-0 USB Wi-Fi Stick",null,null,0]
[]
[null,"Network Accessories",null,null,null,"Qty"]
[null,"4683-TTM-3F","RS-485 Repeater (Needed if you have more than 50 system bus devices)",null,null,0]
[null,"MS-BACEOL-0","End of line Terminator (Used if the SBH100, or VEC controllers are end of line devices on the trunk)",null,null,0]
[null,"CBL-22/3-FC-PLN","System/Zone Bus Cable 22-3C Shielded Plenum Wire",null,null,0]
[null,"CBL-22/3-FC-PVC ","System/Zone Bus Cable 22-3C Shielded NonPlenum Wire",null,null,0]
[null,"CBL-22/2P-SAPLN","Sensor Bus Cable 22-2P Shielded Plenum Wire ",null,null,0]
[null,"CBL-22/2P-SAPVC","Sensor Bus Cable 22-2P Shielded NonPlenum Wire",null,null,0]
[null,"UPSPNL550-0","550 VA/330W Power System Battery Backup and Surge Protection",null,null,0]

{"sheet":"IOM Device","index":2,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[62,1,62,2],[4,1,5,5],[14,1,14,3],[7,1,7,3],[45,1,45,3],[53,1,53,3]]}
[]
[]
[]
[]
[null,"Verasys IOM Device Page"]
[]
[]
[null,"IOM Device"]
[null,"JCI Part Numbers","Descriptions","Qty"]
[null,"LC-VAC1002-0","Verasys Input Output Configurable Controller, NOTE! 4 Binary Inputs, 5 Analog Inputs, 9 Binary Outputs per IOM",0,null,0]
[null,"PA0000004GC0","Panel Enclosure for a single IOM device (12 x 16 x 6.5 in, 40 VA)",0]
[null,"PA0000001AH0","Panel Enclosure for two IOM devices (20 x 24 x 6.5 in, 96 VA)",0]
[null,"PA0000001EH0","Panel Enclosure for three IOM devices (24 x 24 x 6.5 in 96 VA)",0]
[]
[null,"IOM Accessories: Hardwired Input and Output Devices"]
[null,"JCI Part Numbers","Descriptions","Qty"]
[null,"Y65T42-0","120/208/240 to 24V XFR 40VA",0]
[null,"TE-68NT-0N00S","Wall temperature sensor, 1k ohm, nickel with temperature occupancy button.",0]
[null,"TE-6311M-1","8\" Duct Sensor Metal Enclosure, Nickel",0]
[null,"TE-6313P-1","Outside Air Sensor, Nickel",0]
[null,"HE-68N3-0N00WS","Wall Mount Humidity Transmitter w Temp Sensor (3%)",0]
[null,"HE-68P3-0N000","Outdoor Humidity Sensor (3%)",0]
[null,"HE-67N3-0N00P","Duct Humidity Sensor w Temp Sensor (3%)",0]
[null,"CD-W00-00-2","CO2 sensor 0-2000ppm",0]
[null,"2020-T","Door Sensor, Flush Mount Switch, Magnet, Terminals",0]
[null,"2505A","N.O. Closed Loop Type Commercial Door Contact",0]
[null,"MK7-B-CR-VTI","Outdoor Light Level Sensor, 0-250 Ft Candles",0]
[null,"DPT2090-25G","Pressure Sensor, Gage, 25 PSI, 0-5VDC, 0.25%",0]
[null,"TBG16A-600R","Steam Trap Assembly (Pig Tail)",0]
[null,"DPT2640-0R1B","Differential Pressure Sensor -1 to 1 in WC, 0-5VDC (Used for Building Pressure)",0]
[null,"DPT2640-R25D","Differential Pressure Sensor -.25 to .25 in WC, 0-5VDC (Used for Building Pressure)",0]
[null,"A-306-K","Outdoor Static Pressure Sensor (Used for Building Pressure)",0]
[null,"SD-01","Surge Dampener (Used to Dampen Wind Effects on Building Pressure Sensors)",0]
[null,"RPS","Stainless Wall plate (for measuring inside for building pressure)",0]
[null,"RPS-W","White plastic wall plate (for measuring inside building pressure)",0]
[null,"RLD-134A","Refrigerant Leak Detector for R-134A refrigerant. 0-5V, 0-1000PPM",0]
[null,"WD-1B","Water Detector SPDT Contact",0]
[null,"WD-2-T-10","Water Detector Tape Style 10ft",0]
[null,"WD-2-T-25","Water Detector Tape Style 25ft",0]
[null,"CSDSC-C50100L0","Current Switch Device Self Calibrating, 100A Max, No Relay",0]
[null,"CSDSC-C50100L1","Current Switch Device, Self Calibrating, 100A Max with 24v Relay (10A)",0]
[null,"CSDECM-C35200L0","Current Switch Device, Manual Calibrating, 200A Max, No Relay",0]
[null,"CSDECM-C35200L1","Current Switch Device, Manual Calibrating, 200A Max with24v Relay (10A)",0]
[null,"RIBU1C","Enclosed Relay SPDT (10A), 10-30VAC/DC",0]
[]
[null,"IOM Accessories: Hardwired Zone NS Sensors"]
[null,"JCI Part Numbers","Descriptions: Note - Any NS Sensor can be used on the IOM Device","Qty"]
[null,"NS-BTN7003-0","Net Sensor, 120x80, JCI Logo, No Display, No Setpoint Adjust, Hardwired Terminals, Addressable",0]
[null,"NS-BTN7003-2","Net Sensor, 120x80, No Logo, No Display, No Setpoint Adjust, Hardwired Terminals, Addressable",0]
[null,"NS-BHN7003-0","Net Sensor, 120x80, Logo, No Display, No Setpoint Adjust, Hardwired Terminals, 3% Humidity",0]
[null,"NS-BTN7001-0","Net Sensor, 120x80, JCI Logo, No Display, No Setpoint Adjust, Modular Jack, Address 199",0]
[null,"NS-BTN7001-2","Net Sensor, 120x80, No Logo, No Display, No Setpoint Adjust, Modular Jack, Address 199",0]
[]
[null,"IOM Accessories: Wireless Zone NS Sensors"]
[null,"JCI Part Numbers","Descriptions","Qty"]
[null,"WRZ-7860-0","Wireless Receiver, One to Many Sensors REQUIRED IF CONNECTING WIRELESS SENSORS TO VAC1002! ",0]
[null,"ZFR-CBLEXT-0","RJ12 Extension Cable 10\" for the WRZ-7860-0. (Used to plug into Sensor Bus and an extend outside controller panel).",0]
[null,"WRZ-STR0000-0","Wireless Refrigerator/Freezer Temperature Transmitter",0]
[null,"WRZ-RMT10K-0","Wireless Room Temperature Sensor Transmitter for Remote 10K Temperature Probes",0]
[null,"WRZ-TTR0000-0","Wireless Room Temperature Sensor Transmitter with Battery Level/Signal Strength LED, No Setpoint Adjustment",0]
[null,"WRZ-THN0000-0","Wireless Room Temperature and Humidity Sensor Transmitter with Battery Level/Signal Strength LED ",0]

{"sheet":"IOM Device - Energy Meter","index":3,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,1,5,11],[7,1,8,11]]}
[]
[]
[]
[]
[null,"Verasys IOM Energy Meter Part Number Creation"]
[]
[]
[null,"Note: Energy Meter Part Numbers are created by the combination of Phases supported, CVT Amps, and CVT Lead Length. EMC meters are the only meters supported on the Verasys IOM. Input the data in the table below and Click the \"Create Part Number\" Button."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Options","Meter Style","Phase","CVT Amp","CVT Lead Length","Qty"]
[null,"1.","SENVA-01-EMC","?","?","?","?"]
[null,"2.","SENVA-01-EMC","?","?","?","?"]
[null,"3.","SENVA-01-EMC","?","?","?","?"]
[null,"SAMPLE","SENVA-01-EMC","3N","08S","03",1]
[]
[null,null,null,null,null,"JCI Part Numbers","Qty"]
[null,null,null,null,null,"?",0]
[null,null,null,null,null,"?",0]
[null,null,null,null,null,"?",0]

{"sheet":"SZ - Smart Equipment","index":4,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,1,5,3],[7,1,7,2]]}
[]
[]
[]
[]
[null,"Single Zone Smart Equipment Selection Page"]
[]
[]
[null,"NetStats for Zone Temperature"]
[null,"JCI Part Numbers \n(Required)","Typically one Zone Temperature sensor is required per single zone RTU, but Verasys can average up to 3 sensors per RTU. ","Qty"]
[null,"NS-BTB7003-0","Net Sensor, 120x80, JCI Logo, LCD Display, Local Setpoint, Terminals (Dial)",0]
[null,"NS-BTB7003-2","Net Sensor, 120x80, No Logo, LCD Display, Local Setpoint, Terminals (Dial)",0]
[null,"NS-BTN7003-0","Net Sensor, 120x80, JCI Logo, No Display, No Setpoint, Terminals",0]
[null,"NS-BTN7003-2","Net Sensor, 120x80, No Logo, No Display, No Setpoint, Terminals",0]
[null,"NS-BTP7002-0","Net Sensor, 120x80, JCI Logo, No Display, Warmer/Cooler Adjustment, Terminals",0]
[null,"NS-BTP7002-2","Net Sensor, 120x80, No Logo, No Display, Warmer/Cooler Adjustment, Terminals",0]
[null,"NS-BHR7103-0","Net Sensor, 120x80, Logo, LCD Display, Local Setpoint, Terminals, 3% Humidity",0]
[null,"NS-BHP7001-0","Net Sensor, 120x80, Logo, No Display, Warmer/Cooler Adjustment, Terminals, 3% Humidity",0]
[null,"NS-BTB7F03-0","Net Sensor, 120x80, Logo, LCD Display, Local Setpoint, Terminals, use with Title 24 FDD for Economizer",0]
[null,"NS-BTK7002-0","Net Sensor, 120x80, JCI Logo, LCD Display, Local Setpoint, Terminals (Up/Down Buttons)",0]
[null,"NS-BTK7002-2","Net Sensor, 120x80, No Logo, LCD Display, Local Setpoint, Terminals (Up/Down Buttons)",0]
[]
[null,"Zone CO2 Sensor \n(Optional)",null,"Qty"]
[null,"NS-BCN7004-0","BACnet network CO2 sensor 80 mm x 120 mm",0]
[]
[null,"Remember to order the units with a BACnet Card!  If your unit does not have the card below is the part to order."]
[null,"Smart Equipment BACnet Card"]
[null,"JCI Part Numbers",null,"Qty"]
[null,"SE-COM1001-0","Smart Equipment BACnet Communications Card. Required!",0]

{"sheet":"SZ - 3rd Party Equipment","index":5,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[33,1,33,3],[29,2,29,5],[30,2,30,5],[4,1,5,9],[7,1,7,8],[15,1,15,8],[23,1,23,8],[28,2,28,5],[25,2,25,5],[24,2,24,8]]}
[]
[]
[]
[]
[null,"Single Zone Verasys \"3rd Party\" Standard Equipment"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Check Equipment!!!"]
[]
[null,"Wired TEC3000 Thermostats | Verasys Smart Thermostats"]
[]
[null,"JCI Part Number","System Covered","JCI Logo","Htg/Clg Signals","Occupancy Sensor",null,null,"Qty"]
[null,"TEC3630-00-000","RTU, Heatpump, Furnace, Unit Heater","Yes","On/Off","No",null,null,0]
[null,"TEC3631-00-000","RTU, Heatpump, Furnace, Unit Heater","Yes","On/Off","Yes",null,null,0]
[null,"TEC3630-01-000","RTU, Heatpump, Furnace, Unit Heater","No","On/Off","No",null,null,0]
[null,"TEC3631-01-000","RTU, Heatpump, Furnace, Unit Heater","No","On/Off","Yes",null,null,0]
[]
[null,"Verasys Pro Wireless TEC3000 Thermostats | Verasys Smart Wireless Thermostats"]
[]
[null,"JCI Part Number","System Covered","JCI Logo","Htg/Clg Signals","Occupancy Sensor",null,null,"Qty"]
[null,"TEC3030-00-000","RTU, Heatpump, Furnace, Unit Heater","Yes","On/Off","No",null,null,0]
[null,"TEC3031-00-000","RTU, Heatpump, Furnace, Unit Heater","Yes","On/Off","Yes",null,null,0]
[null,"TEC3030-01-000","RTU, Heatpump, Furnace, Unit Heater","No","On/Off","No",null,null,0]
[null,"TEC3031-01-000","RTU, Heatpump, Furnace, Unit Heater","No","On/Off","Yes",null,null,0]
[]
[null,"Verasys Pro Series Wireless Field Bus "]
[null,"JCI Part Number","Product Description"]
[null,"Wireless Coordinator\n (Required)",null,null,null,null,null,null,"Qty"]
[null,"LC-ZFR1825-0","Wireless Coordinator and mounting base with 110/220 VAC power supply and antenna.",null,null,null,null,null,0]
[]
[null,"Wireless Repeaters \n(Optional/Recommended)","Product Description",null,null,null,null,null,"Qty"]
[null,"LC-ZFR1821-0B","Wireless Pro Repeater Kit with EMT mount, 3ft RJ-12 cable, and 24VAC to 15VDC power supply",null,null,null,null,null,0]
[null,"LC-ZFR1822-0B","Wireless Pro Repeater Wall Mount Kit, with 10ft RJ-12 cable and 24VAC to 15VDC power supply. ",null,null,null,null,null,0]
[]
[]
[null,"TEC3000 Accessories"]
[null,"Duct Sensor \n(Optional)","For Supply Air Temperature.  Additional diagnostics supported if connected.  These are support for the RTU, Furnace, Heatpump Models","Qty"]
[null,"TE-6311M-1","8\" Duct Sensor Metal Enclosure, Nickel",0]
[]
[null,"OA-T Sensor \n(Optional)","For Outdoor Air Temperature. Note they are only supported on the RTU, Furnace, Heatpump Models","Qty"]
[null,"TE-6313P-1","Outside Air Sensor, Nickel",0]
[]
[null," Wall Sensor \n(Optional)","For Remote Sensor ","Qty"]
[null,"TE-68NT-0N00S","Wall temperature sensor, 1k ohm, Nickel ",0]
[]
[null," Fan Status \n(Optional)","Fan Status ","Qty"]
[null,"CSD-CF0A0-1","Current switch, Split Core, 0.15 A Fixed Switch Setpoint 0.15 to 200 A Range",0]
[]
[null,"Damper Actuator \n(Optional)","Mixed Air Damper Actuator. If doing economizer control you will NEED to have an outside air temperature sensor above","Qty"]
[null,"M9208-GGA-3","70in-lb spring return actuator proportional",0]
[null,"M9208-250","Remote mounting kit with crankarm and damper linkage. Used when actuator is not directly mounted on a shaft.",0]
[]
[null," Wall Plate","To Cover Larger Opening (Optional)","Qty"]
[null,"TEC-WALLPLT","TEC3000 Wall Plate",0]

{"sheet":"MZ- Zone Coordinator","index":6,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[7,1,7,2],[4,1,5,6]]}
[]
[]
[]
[]
[null,"Multi-Zone Zone Coordinators"]
[]
[]
[null,"Zone Coordinators"]
[null,"JCI Part Numbers","Note: Each Zoning Coordinator can control up to 32 Boxes and/or Zones.  One Coordinator is required per VAV or COBP RTU. ",null,null,"Qty"]
[null,"LC-VZC100-0","Verasys Zoning Coordinator for VAV and COBP applications (Loose Board Version)",null,null,0]
[null,"LC-VZCPNL-0","Verasys Zoning Coordinator for VAV and COBP applications (Panel Version)",null,null,0]
[]
[null,"Transformers","Power for all the Zone Coordinators, VAV Boxes and Zone Controllers",null,null,"Qty"]
[null,"Y65T42-0","120/208/240 to 24V XFR 40VA (Power for 2 Controllers)",null,null,0]
[null,"PSH100A","120V to 24V XFR, 100VA (Power for 6 Controllers)",null,null,0]
[null,"PSH300A","480/277/240/120V to 24V XFR, 3 Circuits 100VA each (Power for 18 Controllers)",null,null,0]
[null,"PSH500A","480/277/240/120V  to 24V XFR,5 Circuits 100VA each (Power for 30 Controllers)",null,null,0]

{"sheet":"MZ- Smart Equipment","index":7,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[4,1,5,9]]}
[]
[]
[]
[]
[null,"Multi-Zone Smart Equipment Page"]
[]
[]
[]
[null,null,"Select unit with BACnet Card.  If the unit does not have a BACnet card add this part."]
[null,"Smart Equipment BACnet Card",null,0]
[null,"JCI Part Numbers",null,0,null,"Qty"]
[null,"SE-COM1001-0","Smart Equipment BACnet Communications Card Required!",0,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[]
[]
[null,null,null,0]
[]
[]
[]
[]
[null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,0]

{"sheet":"MZ- 3rd Party Units","index":8,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,1,5,9],[7,1,7,5],[11,1,11,5]]}
[]
[]
[]
[]
[null,"Multi-Zone \"3rd Party\" Equipment Controller Selection"]
[]
[]
[null,"3rd Party RTU Controller"]
[null,"JCI Part Numbers","If you have a Simplicity Smart Equipment Unit this is not needed",null,null,"Qty"]
[null,"LC-VEC100-0","Verasys Equipment Controller, 3rd Party RTU (VAV, COPB)",null,null,0]
[]
[null,"LC-VEC100-0 3rd Party RTU Controller Accessories"]
[null,"Duct Sensors","For Supply Air Temperature mandatory, Return Air Temperature (Optional). ",null,null,"Qty"]
[null,"TE-6311M-1","8\" Duct Sensor Metal Enclosure, Nickel",null,null,0]
[]
[null,"Differential Pressure Sensors \n(Required for VAV Systems)","Note: Duct Static Pressure is measured on Bypass controller for COBP/VVT Systems. These are required only for VAV.",null,null,"Qty"]
[null,"DPT2640-005D","Low Differential Pressure Transducer 0-5 in WC, 0-5VDC",null,null,0]
[null,"FTG18A-600R","Duct Static Pressure Probe.  Need one per DPT",null,null,0]
[]
[null,"OA-T Sensor \n(Optional)","For Outdoor Air Temperature ",null,null,"Qty"]
[null,"TE-6313P-1","Outside Air Sensor, Nickel",null,null,0]
[]
[null,"Filter Status \n(Optional)","Filter Status",null,null,"Qty"]
[null,"P32AC-2C","Differential Pressure Switch, Single-Pole, Double-Throw (SPDT), 0.05 to 5 in. W.C.",null,null,0]
[null,"FTG18A-600R","Duct Static Pressure Probe Kit: 4 in. Flanged Sensing Tube",null,null,0]
[]
[null,"Fan Status\n (Optional)","Fan Status ",null,null,"Qty"]
[null,"CSD-CF0A0-1","Current switch, Split Core, 0.15 A Fixed Switch Setpoint 0.15 to 200 A Range",null,null,0]
[]
[null,"Return CO2 Sensor","Return Air CO2 Sensor (Optional) But Required for Demand Ventilation Control",null,null,"Qty"]
[null,"CD-P1000-00-00","Duct Mount CO2 Transmitter 0–10 VDC, 0–2,000 ppm CO2",null,null,0]
[]
[null,"Zone Humidity \n(Optional)","Zone Humidity",null,null,"Qty"]
[null,"NS-BHN7003-0","Netstat, 3% Humidity, addressable",null,null,0]
[]
[null,"Damper Actuator","Mixed Air Damper Actuator (Optional) If doing economizer control you will need to have an outside air temperature sensor",null,null,"Qty"]
[null,"M9208-GGA-3","70in-lb spring return actuator proportional",null,null,0]
[null,"M9208-250","Remote mounting kit with crankarm and damper linkage. Used when actuator is not directly mounted on a shaft.",null,null,0]

{"sheet":"MZ- VAV Zones","index":9,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,1,5,5],[7,1,7,2],[13,1,13,2]]}
[]
[]
[]
[]
[null,"Multi-Zone VAV Controller Selection Page"]
[]
[]
[null,"VAV Controllers"]
[null,"JCI Part Numbers","Pick the model that covers the heating you need.  All models can do cooling only.",null,"Qty"]
[null,"LC-ZEC410-1","Configurable VAV Box Controller, All Fan Types, Stg Box Htg",null,0]
[null,"LC-ZEC410-2","Configurable VAV Box Controller, All Fan Types, Inc Box Htg",null,0]
[null,"LC-ZEC410-3","Configurable VAV Box Controller, All Fan Types, Prop(SCR) Box Htg",null,0]
[]
[null,"NetStats for Zone Temperature",null,null,"Qty"]
[null,"NS-BTB7003-0","Net Sensor, 120x80, JCI Logo, LCD Display, Local Setpoint, Terminals (Dial)",null,0]
[null,"NS-BTB7003-2","Net Sensor, 120x80, No Logo, LCD Display, Local Setpoint, Terminals (Dial)",null,0]
[null,"NS-BTN7003-0","Net Sensor, 120x80, JCI Logo, No Display, No Setpoint, Terminals",null,0]
[null,"NS-BTN7003-2","Net Sensor, 120x80, No Logo, No Display, No Setpoint, Terminals",null,0]
[null,"NS-BTP7002-0","Net Sensor, 120x80, JCI Logo, No Display, Warmer/Cooler Adjustment, Terminals",null,0]
[null,"NS-BTP7002-2","Net Sensor, 120x80, No Logo, No Display, Warmer/Cooler Adjustment, Terminals",null,0]
[null,"NS-BTK7002-0","Net Sensor, 120x80, JCI Logo, LCD Display, Local Setpoint, Terminals (Up/Down Buttons)",null,0]
[null,"NS-BTK7002-2","Net Sensor, 120x80, No Logo, LCD Display, Local Setpoint, Terminals (Up/Down Buttons)",null,0]
[]
[null,"Duct Sensors \n(Recommended)","Discharge Sensors for ZEC Controllers",null,"Qty"]
[null,"TE-631GV-2","4\" Duct Sensor for VAV Flange Mount, Nickel, 10ft plenum Cable",null,0]
[]
[null,"Zone CO2 Sensor \n(Optional)","Optional",null,"Qty"]
[null,"NS-BCN7004-0","BACnet network CO2 sensor 80 mm x 120 mm",null,0]
[]
[null,"Occupancy Lighting Switch \n(Optional)","Optional Occupancy Switch Controls Lights and Powers Field Relay",null,"Qty"]
[null,"OLS-2100-1","Occupancy Lighting Switch",null,0]
[null,"RIBU1C","Enclosed relay for OLS-2100-1 sensor",null,0]
[]
[null,"Balance Stat \n(Optional)","Optional.  Network thermostat used by balance contractors to balance the VAV boxes",null,"Qty"]
[null,"NS-ATV7003-0","VAV Box Balancing Thermostat",null,0]

{"sheet":"MZ - COBP Zones","index":10,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[43,1,43,2],[4,1,5,8],[11,7,23,7],[24,7,36,7],[7,1,7,2],[39,1,39,2]]}
[]
[]
[]
[]
[null,"Multi-Zone COBP Zone Damper Selection Page"]
[]
[]
[null,"COBP Zone Dampers/Controllers"]
[null,"JCI Part Numbers",null,null,null,"Qty"]
[null,"LC-ZEC310-0","Field Installed, Zone Damper Controller No Damper",null,null,0]
[null,"RCG04B","4\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG06B","6\" Round Zone/Bypass Damper No Controller ",null,null,0,null,"5 Day Lead-time"]
[null,"RCG07B","7\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG08B","8\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG09B","9\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG10B","10\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG11B","11\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG12B","12\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG13B","13\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG14B","14\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG15B","15\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG16B","16\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG17B","17\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG18B","18\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RZV06Z","6\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,"RZV07Z","7\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,"RZV08Z","8\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,"RZV09Z","9\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,"RZV10Z","10\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,"RZV11Z","11\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,"RZV12Z","12\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,"RZV13Z","13\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,"RZV14Z","14\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,"RZV15Z","15\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,"RZV16Z","16\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,"RZV17Z","17\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,"RZV18Z","18\" Round Zone Damper LC-ZEC310-0 Controller ",null,null,0]
[null,null,"Rectangular dampers are supported up to 30\"x30\".  Order dampers separately and connect LC-ZEC310-0 "]
[]
[null,"Zone Temperature Sensors Option 1 (Hardwired)",null,null,null,"Qty"]
[null,"TE-68NT-0N00S","Wall temperature sensor, 1k ohm, nickel with temperature occupancy button.",null,null,0]
[null,"TE-68NT-1N00S","Wall temperature sensor, 1k ohm,nickel with warmer/cooler (W/C) adjustment and temperature occupancy pushbutton.",null,null,0]
[]
[null,"Zone Temperature Sensors Option 2 (NetStats - Recommended) ",null,null,null,"Qty"]
[null,"NS-BTB7003-0","Net Sensor, 120x80, JCI Logo, LCD Display, Local Setpoint, Terminals",null,null,0]
[null,"NS-BTB7003-2","Net Sensor, 120x80, No Logo, LCD Display, Local Setpoint, Terminals",null,null,0]
[null,"NS-BTN7003-0","Net Sensor, 120x80, JCI Logo, No Display, No Setpoint, Terminals",null,null,0]
[null,"NS-BTN7003-2","Net Sensor, 120x80, No Logo, No Display, No Setpoint, Terminals",null,null,0]
[null,"NS-BTP7002-0","Net Sensor, 120x80, JCI Logo, No Display, Warmer/Cooler Adjustment, Terminals",null,null,0]
[null,"NS-BTP7002-2","Net Sensor, 120x80, No Logo, No Display, Warmer/Cooler Adjustment, Terminals",null,null,0]
[null,"NS-BTK7002-0","Net Sensor, 120x80, JCI Logo, LCD Display, Local Setpoint, Terminals (Up/Down Buttons)",null,null,0]
[null,"NS-BTK7002-2","Net Sensor, 120x80, No Logo, LCD Display, Local Setpoint, Terminals (Up/Down Buttons)",null,null,0]
[]
[null,"Occupancy Lighting Switch \n(Optional)","Optional Occupancy Switch Controls Lights and Powers Field Relay",null,null,"Qty"]
[null,"OLS-2100-1","Occupancy Lighting Switch",null,null,0]
[null,"RIBU1C","Enclosed relay for OLS-2100-1 sensor",null,null,0]
[]
[null,"Zone CO2 Sensor \n(Optional)","Optional CO2 Sensor",null,null,"Qty"]
[null,"NS-BCN7004-0","BACnet network CO2 sensor 80 mm x 120 mm",null,null,0]
[]
[null,"Second Zone Damper Actuator \n(Optional)","You will need to buy the actuator and add it to a damper without a ZEC310",null,null,"Qty"]
[null,"M9310-HGA-2","10NM Torque Non-Spring Return Damper Actuator",null,null,0]

{"sheet":"MZ- Bypass Damper","index":11,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[10,7,22,7],[23,7,35,7],[7,1,7,2],[4,1,5,8]]}
[]
[]
[]
[]
[null,"Multi-Zone COBP Bypass Controller Selection Page"]
[]
[]
[null,"Bypass Control"]
[null,"JCI Part Numbers",null,null,null,"Qty"]
[null,"LC-BYP200-0","Field Installed, Bypass Damper Controller - No Damper",null,null,0]
[null,"RCG06B","6\" Round Zone/Bypass Damper No Controller ",null,null,0,null,"5 Day Lead-time"]
[null,"RCG07B","7\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG08B","8\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG09B","9\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG10B","10\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG11B","11\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG12B","12\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG13B","13\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG14B","14\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG15B","15\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG16B","16\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG17B","17\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RCG18B","18\" Round Zone/Bypass Damper No Controller ",null,null,0]
[null,"RZV06Y","6\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0,null,"15 Day Lead-time"]
[null,"RZV07Y","7\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0]
[null,"RZV08Y","8\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0]
[null,"RZV09Y","9\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0]
[null,"RZV10Y","10\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0]
[null,"RZV11Y","11\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0]
[null,"RZV12Y","12\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0]
[null,"RZV13Y","13\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0]
[null,"RZV14Y","14\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0]
[null,"RZV15Y","15\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0]
[null,"RZV16Y","16\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0]
[null,"RZV17Y","17\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0]
[null,"RZV18Y","18\" Round Bypass Damper LC-BYP200-0 Controller *",null,null,0]
[null,null,"Rectangular dampers are supported up to 30\"x30\".  Order dampers separately and connect LC-ZEC310-0 or LC-BYP200-0"]
[null,null,"* Bypass Dampers come with Controller but without Differential Pressure Sensors"]
[]
[null,"Differential Pressure Sensor \n(Required)","1 each required for each LC-BYP200-0",null,null,"Qty"]
[null,"DPT2640-005D","Low Differential Pressure Transducer 0-5 in WC, 0-5VDC",null,null,0]
[null,"FTG18A-600R","Duct Static Pressure Probe.  Need one per DPT",null,null,0]
[]
[null,"Transformers",null,null,null,"Qty"]
[null,"Y65T42-0","120/208/240 to 24V XFR 40VA (Power for 2 Boxes)",null,null,0]
[]
[]
[null,"Second Bypass Damper Actuator","You will need to buy the actuator and add it to a damper without a BYP200",null,null,"Qty"]
[null,"M9310-HGA-2","10NM Torque Non-Spring Return Damper Actuator",null,null,0]

{"sheet":"Adv. Application Controller","index":12,"n_rows":75,"n_cols":11,"rows_kept":75,"cut":false,"hidden":false,"merged":[[71,2,71,6],[66,1,66,6],[67,2,67,6],[68,2,68,3],[69,2,69,3],[70,2,70,3],[40,1,40,6],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[64,2,64,3],[55,2,55,3],[56,2,56,3],[60,2,60,3],[51,1,51,6],[52,2,52,3],[53,2,53,3],[54,2,54,3],[58,1,58,6],[59,2,59,3],[62,1,62,6],[63,2,63,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[31,2,31,3],[35,2,35,3],[33,2,33,3],[21,2,21,3],[22,2,22,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[23,2,23,3],[73,2,73,3],[74,2,74,3],[4,1,5,7],[8,1,8,6],[13,1,13,6],[10,2,10,3],[11,2,11,3],[9,2,9,3],[32,2,32,3],[14,2,14,6],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3]]}
[]
[]
[]
[]
[null,"Verasys \"3rd Party\" Advanced Application Controller"]
[]
[]
[]
[null,"LC-VAC-x000 Controllers | Verasys Application Controller"]
[null,"JCI Part Number","Description",null,null,null,"Qty"]
[null,"LC-VAC1000-0","18 Point 24v, Application Controller with no application loaded",null,null,null,0]
[null,"LC-VAC3000-0","32 Point 24v, Application Controller with no application loaded",null,null,null,0,null,null,null,"Check Applications!!!"]
[]
[null,"18 Point VAC Application Controller Accessories"]
[null,"JCI Part Number","Description"]
[null,"Duct Sensors","Note: For Supply Air Temperature (Required), or Return Air Temperature (Optional). ",null,null,null,"Qty"]
[null,"TE-6311M-1\n(Required)","8\" Duct Sensor Metal Enclosure, Nickel (minimum one Required)",null,null,null,0]
[]
[null,"MA-T Sensor \n(Optional/Required)","Note: If you have proportional heating or cooling and economizer (Required).",null,null,null,"Qty"]
[null,"TE-6315M-1","Outside Air Sensor, Nickel",null,null,null,0]
[]
[null,"OA-T Sensor \n(Optional/Required)","For Outdoor Air Temperature, Required for economizer control.",null,null,null,"Qty"]
[null,"TE-6313P-1","Outside Air Sensor, Nickel",null,null,null,0]
[]
[null,"Fan Status\n (Optional)","Fan Status ",null,null,null,"Qty"]
[null,"CSDECM-C35200L0","Current switch, Split Core, 0.15 A Fixed Switch Setpoint 0.15 to 200 A Range",null,null,null,0]
[]
[null,"LT-A Sensors\n (Optional/Required)","Low Temperature Alarm, when you have water coils and economizer (Required). ",null,null,null,"Qty"]
[null,"A70HA-1C","See below",null,null,null,0]
[null,"TE-6001-8","Need one per A70HA-1C!",null,null,null,0]
[]
[null,"OCC-S Sensor\n (Optional)","Occupancy Sensor. Lighting switch plus relayed used to switch off lights when motion is not sensed.",null,null,null,"Qty"]
[null,"OLS-2100-1","See below",null,null,null,0]
[null,"RIBU1C","Need one per OLS-2100-1",null,null,null,0]
[]
[null,"Damper Actuator \n(Optional)","Mixed Air Damper Actuator (Optional) If doing economizer control you will need to have an outside air temperature sensor",null,null,null,"Qty"]
[null,"M9208-GGA-3","70in-lb spring return actuator proportional",null,null,null,0]
[null,"M9208-250","Remote mounting kit with crankarm and damper linkage. Used when actuator is not directly mounted on a shaft.",null,null,null,0]
[]
[]
[null,"Hardwired Zone Temperature Only Sensor | NS Sensors (Sensor Bus)"]
[null,"JCI Part Numbers \n(One Required)","Description: Note Minimum One NS Sensor is Required per VAC Application Controller",null,null,null,"Qty"]
[null,"NS-BTB7003-0","Net Sensor, 120x80, JCI Logo, LCD Display, Local Setpoint Adjust, Terminals (Dial)",null,null,null,0]
[null,"NS-BTB7003-2","Net Sensor, 120x80, No Logo, LCD Display, Local Setpoint Adjust, Terminals (Dial)",null,null,null,0]
[null,"NS-BTN7003-0","Net Sensor, 120x80, JCI Logo, No Display, No Setpoint Adjust, Terminals",null,null,null,0]
[null,"NS-BTN7003-2","Net Sensor, 120x80, No Logo, No Display, No Setpoint Adjust, Terminals",null,null,null,0]
[null,"NS-BTP7002-0","Net Sensor, 120x80, JCI Logo, No Display, Warmer/Cooler Adjustment, Terminals",null,null,null,0]
[null,"NS-BTP7002-2","Net Sensor, 120x80, No Logo, No Display, Warmer/Cooler Adjustment, Terminals",null,null,null,0]
[null,"NS-BTJ7002-0","Net Sensor, 120x80, JCI Logo, LCD Display, Local Setpoint Adjust, Terminals (Up/Down Buttons)",null,null,null,0]
[null,"NS-BTJ7002-2","Net Sensor, 120x80, No Logo, LCD Display, Local Setpoint Adjust, Terminals (Up/Down Buttons)",null,null,null,0]
[]
[null,"Hardwired Zone Temperature Sensor + Humidity Sensors | NS Sensors (Sensor Bus)"]
[null,"JCI Part Numbers \n(One Required)","Description: Note Minimum One NS Sensor is Required per VAC Application Controller",null,null,null,"Qty"]
[null,"NS-BHR7103-0","Net Sensor, 120x80, Logo, LCD Display, Local Setpoint Adjust, Terminals, 3% Humidity",null,null,null,0]
[null,"NS-BHN7003-0","Net Sensor, 120x80, Logo, No Display, No Setpoint Adjust, Terminals, 3% Humidity",null,null,null,0]
[null,"NS-BHP7003-0","Net Sensor, 120x80, Logo, No Display, Warmer/Cooler Adjustment, Terminals, 3% Humidity",null,null,null,0]
[null,"NS-BHM7103-2","Net Sensor, 120x80, Logo, LCD Display, Local Setpoint Adjust, Terminals, 3% Humidity, (Up/Down Buttons)",null,null,null,0]
[]
[null,"Hardwired Zone Temperature Sensor + FDD Sensor| NS Sensors (Sensor Bus)"]
[null,"JCI Part Numbers \n(One Required)","Description: Note Minimum One NS Sensor is Required per VAC Application Controller",null,null,null,"Qty"]
[null,"NS-BTB7F03-0","Net Sensor, 120x80, No Logo, LCD Display, Local Setpoint Adjust, Terminals, use with Title 24 FDD for Economizer Alarms",null,null,null,0]
[]
[null,"Hardwired Zone Temperature Sensor + CO2| NS Sensors (Sensor Bus)"]
[null,"JCI Part Numbers \n(One Required)","Description: Note Minimum One NS Sensor is Required per VAC Application Controller",null,null,null,"Qty"]
[null,"NS-BCN7004-0","BACnet network CO2 sensor 80 mm x 120 mm, requires 24VAC Power",null,null,null,0]
[]
[null,"Additional Sensors for the 32 Point ONLY VAC Application Controller"]
[null,"JCI Part Number","Description"]
[null,"Duct Sensors",null,null,null,null,"Qty"]
[null,"HE-67N3-0N00P","Duct Humidity Sensor w Temp Sensor (3%)",null,null,null,0]
[null,"CD-P1000-00-00","Duct CO2 Sensor, 0-2000 PPM, 0 - 10 VDC",null,null,null,0]
[]
[null,"Filter Status \n(Optional)",null,null,null,null,"Qty"]
[null,"P32AC-2C","Differential Pressure Switch, Single-Pole, Double-Throw (SPDT), 0.05 to 5 in. W.C.",null,null,null,0]
[null,"FTG18A-600R","Duct Static Pressure Probe Kit: 4 in. Flanged Sensing Tube",null,null,null,0]

{"sheet":"Fan Coil Units","index":13,"n_rows":67,"n_cols":8,"rows_kept":67,"cut":false,"hidden":false,"merged":[[47,2,47,5],[7,1,7,6],[4,1,5,7],[26,1,26,6],[45,1,45,6],[46,2,46,5],[50,2,50,5],[51,2,51,5],[52,2,52,5],[54,1,54,3],[49,1,49,6]]}
[]
[]
[]
[]
[null,"Fan Coil Unit Selection Page"]
[]
[]
[null,"Wired TEC300 Thermostats | Verasys Smart FanCoil Thermostats"]
[null,"JCI Part Numbers","System Covered","JCI Logo","Htg/Clg Signals","Occupancy Sensor","Humidity Control","Qty"]
[null,"TEC3610-00-000","Fan Coil On/Off or Floating Outputs","Yes","On/Off or Floating","No","No",0]
[null,"TEC3611-00-000","Fan Coil On/Off or Floating Outputs","Yes","On/Off or Floating","Yes","No",0]
[null,"TEC3612-00-000","Fan Coil On/Off or Floating Outputs","Yes","On/Off or Floating","No","Yes",0]
[null,"TEC3613-00-000","Fan Coil On/Off or Floating Outputs","Yes","On/Off or Floating","Yes","Yes",0]
[null,"TEC3620-00-000","Fan Coil Proportional Outputs","Yes","0-10VDC","No","No",0]
[null,"TEC3621-00-000","Fan Coil Proportional Outputs","Yes","0-10VDC","Yes","No",0]
[null,"TEC3622-00-000","Fan Coil Proportional Outputs","Yes","0-10VDC","No","Yes",0]
[null,"TEC3623-00-000","Fan Coil Proportional Outputs","Yes","0-10VDC","Yes","Yes",0]
[null,"TEC3610-01-000","Fan Coil On/Off or Floating Outputs","No","On/Off or Floating","No","No",0]
[null,"TEC3611-01-000","Fan Coil On/Off or Floating Outputs","No","On/Off or Floating","Yes","No",0]
[null,"TEC3612-01-000","Fan Coil On/Off or Floating Outputs","No","On/Off or Floating","No","Yes",0]
[null,"TEC3613-01-000","Fan Coil On/Off or Floating Outputs","No","On/Off or Floating","Yes","Yes",0]
[null,"TEC3620-01-000","Fan Coil Proportional Outputs","No","0-10VDC","No","No",0]
[null,"TEC3621-01-000","Fan Coil Proportional Outputs","No","0-10VDC","Yes","No",0]
[null,"TEC3622-01-000","Fan Coil Proportional Outputs","No","0-10VDC","No","Yes",0]
[null,"TEC3623-01-000","Fan Coil Proportional Outputs","No","0-10VDC","Yes","Yes",0]
[]
[null,"Verasys Pro Wireless TEC3000 Thermostats | Verasys Smart Wireless FanCoil Thermostats"]
[null,"JCI Part Numbers","System Covered","JCI Logo","Htg/Clg Signals","Occupancy Sensor","Humidity Control","Qty"]
[null,"TEC3010-00-000","Fan Coil On/Off or Floating Outputs","Yes","On/Off or Floating","No","No",0]
[null,"TEC3011-00-000","Fan Coil On/Off or Floating Outputs","Yes","On/Off or Floating","Yes","No",0]
[null,"TEC3012-00-000","Fan Coil On/Off or Floating Outputs","Yes","On/Off or Floating","No","Yes",0]
[null,"TEC3013-00-000","Fan Coil On/Off or Floating Outputs","Yes","On/Off or Floating","Yes","Yes",0]
[null,"TEC3020-00-000","Fan Coil Proportional Outputs","Yes","0-10VDC","No","No",0]
[null,"TEC3021-00-000","Fan Coil Proportional Outputs","Yes","0-10VDC","Yes","No",0]
[null,"TEC3022-00-000","Fan Coil Proportional Outputs","Yes","0-10VDC","No","Yes",0]
[null,"TEC3023-00-000","Fan Coil Proportional Outputs","Yes","0-10VDC","Yes","Yes",0]
[null,"TEC3010-01-000","Fan Coil On/Off or Floating Outputs","No","On/Off or Floating","No","No",0]
[null,"TEC3011-01-000","Fan Coil On/Off or Floating Outputs","No","On/Off or Floating","Yes","No",0]
[null,"TEC3012-01-000","Fan Coil On/Off or Floating Outputs","No","On/Off or Floating","No","Yes",0]
[null,"TEC3013-01-000","Fan Coil On/Off or Floating Outputs","No","On/Off or Floating","Yes","Yes",0]
[null,"TEC3020-01-000","Fan Coil Proportional Outputs","No","0-10VDC","No","No",0]
[null,"TEC3021-01-000","Fan Coil Proportional Outputs","No","0-10VDC","Yes","No",0]
[null,"TEC3022-01-000","Fan Coil Proportional Outputs","No","0-10VDC","No","Yes",0]
[null,"TEC3023-01-000","Fan Coil Proportional Outputs","No","0-10VDC","Yes","Yes",0]
[]
[null,"Verasys Pro Series Wireless Field Bus "]
[null,"JCI Part Number"]
[null,"Wireless Coordinator\n (Required)","Product Description",null,null,null,"Qty"]
[null,"LC-ZFR1825-0","Wireless Coordinator and mounting base with 110/220 VAC power supply and antenna.",null,null,null,0]
[]
[null,"Wireless Repeaters","Product Description",null,null,null,"Qty"]
[null,"LC-ZFR1821-0B","Wireless Pro Repeater Kit with EMT mount, 3ft RJ-12 cable, and 24VAC to 15VDC power supply",null,null,null,0]
[null,"LC-ZFR1822-0B","Wireless Pro Repeater Wall Mount Kit, with 10ft RJ-12 cable and 24VAC to 15VDC power supply. ",null,null,null,0]
[]
[null,"TEC3000 Accessories"]
[]
[null,"Duct Sensor \n(Optional)","For Supply Air Temperature (Optional).  Additional diagnostics supported if connected.  These are support for the RTU, Furnace, Heatpump Models","Qty"]
[null,"TE-6311M-1","8\" Duct Sensor Metal Enclosure, Nickel",0]
[]
[null," Wall Sensor \n(Optional)","For Remote Sensor (Optional)","Qty"]
[null,"TE-68NT-0N00S","Wall temperature sensor, 1k ohm, Nickel ",0]
[]
[null,"Fan Status \n(Optional)","Fan Status (Optional)","Qty"]
[null,"CSD-CF0A0-1","Current switch, Split Core, 0.15 A Fixed Switch Setpoint 0.15 to 200 A Range",0]
[]
[null," Wall Plate \n(Optional)","To Cover Larger Opening (Optional)","Qty"]
[null,"TEC-WALLPLT","TEC3000 Wall Plate",0]

{"sheet":"Lighting","index":14,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[67,2,67,3],[68,2,68,3],[69,2,69,3],[70,2,70,6],[59,2,59,3],[61,1,61,6],[62,2,62,3],[63,2,63,3],[65,1,65,6],[66,2,66,6],[58,2,58,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[50,1,50,6],[51,2,51,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[57,1,57,6],[44,2,44,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,1,39,6],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[18,2,18,3],[4,1,5,7],[8,1,8,6],[9,2,9,3],[10,2,10,3],[12,1,12,6],[13,2,13,6],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3]]}
[]
[]
[]
[]
[null,"Verasys Lighting Controller"]
[]
[]
[]
[null,"LC-VAC1001 Controllers | Verasys Lighting Applications"]
[null,"JCI Part Number","Description",null,null,null,"Qty"]
[null,"LC-VAC1001-0","18 Point 24v, Application Controller with Lighting Application",null,null,null,0]
[]
[null,"Lighting Accessories"]
[null,"JCI Part Number","Description"]
[null,"Light Sensors",null,null,null,null,"Qty"]
[null,"MK7-B-CR-VTI","Outdoor Light Level Sensor, 0-250 Ft Candles",null,null,null,0]
[null,"MK7-B-CCF-VTI","Indoor Light Level Sensor, 0-100 Ft Candles",null,null,null,0]
[]
[null,"OCC-S Sensor\n (Optional)","Occupancy Sensor. Lighting switch plus relay used to switch off lights when motion is not sensed.",null,null,null,"Qty"]
[null,"OLS-2100-1","See below",null,null,null,0]
[null,"RIBU1C","Need one per OLS-2100-1",null,null,null,0]

{"sheet":"BOM","index":15,"n_rows":281,"n_cols":7,"rows_kept":281,"cut":false,"hidden":false,"merged":[[10,0,10,6],[9,0,9,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This page is a summary of what was selected in the previous pages"]
["Bill of Materials"]
["System","Function","Source 1 Part No","JCI Part No","Description","Qty","Video Tracks"]
["Network","Smart Building Hub",{"$f":"VLOOKUP(D13,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LC-SBH200-0"},"LC-SBH200-0","Verasys Smart Building Hub",{"$f":"Network!F10","v":0},"Video Available!"]
["Network","Smart Building Hub Power",{"$f":"VLOOKUP(D14,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"ACC-PWRKIT-1A24","Verasys LC-SBH200-0 Power Supply",{"$f":"Network!F13","v":0}]
["Network","Smart Building Hub WiFi",{"$f":"VLOOKUP(D15,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"ACC-WIFIKIT-ODU","Verasys LC-SBH200-0 USB Wi-Fi Stick",{"$f":"Network!F14","v":0}]
["Network","BACnet MSTP Repeater",{"$f":"VLOOKUP(D16,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-4683-TTM-3F"},"4683-TTM-3F","RS-485 Repeater (Needed if you have more than 50 system bus devices)",{"$f":"Network!F17","v":0}]
["Network","BACnet MSTP EOL",{"$f":"VLOOKUP(D17,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-MS-BACEOL-0"},"MS-BACEOL-0","End of line Terminator (Used if the SBH100, or VEC controllers are end of line devices on the trunk)",{"$f":"Network!F18","v":0}]
["Network","Communication Wire",{"$f":"VLOOKUP(D18,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"CBL-22/3-FC-PLN","System Bus Cable 22-3C Shielded Plenum Wire",{"$f":"Network!F19","v":0}]
["Network","Communication Wire",{"$f":"VLOOKUP(D19,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"CBL-22/3-FC-PVC ","System Bus Cable 22-3C Shielded NonPlenum Wire",{"$f":"Network!F20","v":0}]
["Network","Communication Wire",{"$f":"VLOOKUP(D20,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"CBL-22/2P-SAPLN","Sensor Bus Cable 22-2P Shielded Plenum Wire ",{"$f":"Network!F21","v":0}]
["Network","Communication Wire",{"$f":"VLOOKUP(D21,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"CBL-22/2P-SAPVC","Sensor Bus Cable 22-2P Shielded NonPlenum Wire",{"$f":"Network!F22","v":0}]
["Network","Battery Backup",{"$f":"VLOOKUP(D22,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"UPSPNL550-0","550 VA/330W Power System Battery Backup and Surge Protection",{"$f":"Network!F23","v":0}]
["I/O Module","IOM Device",{"$f":"VLOOKUP(D23,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LCVAC1002-0"},"LC-VAC1002-0","Verasys IOM Device, 4 BI, 5 AI, 9 BO, 24v",{"$f":"'IOM Device'!D10","v":0},"Video Available!"]
["I/O Module","IOM Panel",{"$f":"VLOOKUP(D24,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"PA0000004GC0","Panel Enclosure for a single IOM device (12 x 16 x 6.5 in, 40 VA)",{"$f":"'IOM Device'!D11","v":0}]
["I/O Module","IOM Panel",{"$f":"VLOOKUP(D25,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"PA0000001AH0","Panel Enclosure for two IOM devices (20 x 24 x 6.5 in, 96 VA)",{"$f":"'IOM Device'!D12","v":0}]
["I/O Module","IOM Panel",{"$f":"VLOOKUP(D26,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"PA0000001EH0","Panel Enclosure for three IOM devices (24 x 24 x 6.5 in 96 VA)",{"$f":"'IOM Device'!D13","v":0}]
["I/O Module","IOM Transformer",{"$f":"VLOOKUP(D27,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-Y65T42-0"},"Y65T42-0","120/208/240 to 24V XFR 40VA",{"$f":"'IOM Device'!D17","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D28,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE68NT1N00S"},"TE-68NT-0N00S","Wall temperature sensor, 1k ohm, nickel with temperature occupancy button.",{"$f":"'IOM Device'!D18","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D29,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE-6311M-1"},"TE-6311M-1","8\" Duct Sensor Metal Enclosure, Nickel",{"$f":"'IOM Device'!D19","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D30,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE-6313P-1"},"TE-6313P-1","Outside Air Sensor, Nickel",{"$f":"'IOM Device'!D20","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D31,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-H68N30N00WS"},"HE-68N3-0N00WS","Wall Mount Humidity Transmitter w Temp Sensor (3%)",{"$f":"'IOM Device'!D21","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D32,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-H68P30N000"},"HE-68P3-0N000","Outdoor Humidity Sensor (3%)",{"$f":"'IOM Device'!D22","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D33,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-H67N30N00P"},"HE-67N3-0N00P","Duct Humidity Sensor w Temp Sensor (3%)",{"$f":"'IOM Device'!D23","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D34,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-CDW-00-00-2"},"CD-W00-00-2","CO2 sensor 0-2000ppm",{"$f":"'IOM Device'!D24","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D35,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"2020-T","Door Sensor, Flush Mount Switch, Magnet, Terminals",{"$f":"'IOM Device'!D25","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D36,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"2505A","N.O. Closed Loop Type Commercial Door Contact",{"$f":"'IOM Device'!D26","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D37,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"MK7-B-CR-VTI","Outdoor Light Level Sensor, 0-250 Ft Candles",{"$f":"'IOM Device'!D27","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D38,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-DPT2090-25G"},"DPT2090-25G","Pressure Sensor, Gage, 25 PSI, 0-5VDC, 0.25%",{"$f":"'IOM Device'!D28","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D39,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TBG16A-600R"},"TBG16A-600R","Steam Trap Assembly (Pig Tail)",{"$f":"'IOM Device'!D29","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D40,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-DPT26400R1B"},"DPT2640-0R1B","Differential Pressure Sensor -1 to 1 in WC, 0-5VDC (Used for Building Pressure)",{"$f":"'IOM Device'!D30","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D41,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-DPT2640R25D"},"DPT2640-R25D","Differential Pressure Sensor -.25 to .25 in WC, 0-5VDC (Used for Building Pressure)",{"$f":"'IOM Device'!D31","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D42,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-A-306-K"},"A-306-K","Outdoor Static Pressure Sensor (Used for Building Pressure)",{"$f":"'IOM Device'!D32","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D43,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-SD-01"},"SD-01","Surge Dampener (Used to Dampen Wind Effects on Building Pressure Sensors)",{"$f":"'IOM Device'!D33","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D44,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RPS"},"RPS","Stainless Wall plate (for measuring inside for building pressure)",{"$f":"'IOM Device'!D34","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D45,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RPS-W"},"RPS-W","White plastic wall plate (for measuring inside building pressure)",{"$f":"'IOM Device'!D35","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D46,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RLD-134A"},"RLD-134A","Refrigerant Leak Detector for R-134A refrigerant. 0-5V, 0-1000PPM",{"$f":"'IOM Device'!D36","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D47,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-WD-1B"},"WD-1B","Water Detector SPDT Contact",{"$f":"'IOM Device'!D37","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D48,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-WD-2-T-10"},"WD-2-T-10","Water Detector Tape Style 10ft",{"$f":"'IOM Device'!D38","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D49,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-WD-2-T-25"},"WD-2-T-25","Water Detector Tape Style 25ft",{"$f":"'IOM Device'!D39","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D50,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-CSDSCC50100L0"},"CSDSC-C50100L0","Current Switch Device Self Calibrating, 100A Max, No Relay",{"$f":"'IOM Device'!D40","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D51,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-CSDSCC50100L1"},"CSDSC-C50100L1","Current Switch Device, Self Calibrating, 100A Max with 24v Relay (10A)",{"$f":"'IOM Device'!D41","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D52,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-CSDECMC35200L0"},"CSDECM-C35200L0","Current Switch Device, Manual Calibrating, 200A Max, No Relay",{"$f":"'IOM Device'!D42","v":0}]
["I/O Module","I/O",{"$f":"VLOOKUP(D53,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-CSDECMC35200L1"},"CSDECM-C35200L1","Current Switch Device, Manual Calibrating, 200A Max with24v Relay (10A)",{"$f":"'IOM Device'!D43","v":0}]
["I/O Module","IOM Relay",{"$f":"VLOOKUP(D54,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RIBU1C"},"RIBU1C","Enclosed Relay SPDT (10A), 10-30VAC/DC",{"$f":"'IOM Device'!D44","v":0}]
["I/O Module","IOM NS Sensor",{"$f":"VLOOKUP(D55,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTN7003-0"},"NS-BTN7003-0","Net Sensor, 120x80, JCI Logo, No Display, No Setpoint Adjust, Hardwired Terminals, Addressable",{"$f":"'IOM Device'!D48","v":0}]
["I/O Module","IOM NS Sensor",{"$f":"VLOOKUP(D56,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTN7003-2"},"NS-BTN7003-2","Net Sensor, 120x80, No Logo, No Display, No Setpoint Adjust, Hardwired Terminals, Addressable",{"$f":"'IOM Device'!D49","v":0}]
["I/O Module","IOM NS Sensor",{"$f":"VLOOKUP(D57,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBHN7003-0"},"NS-BHN7003-0","Net Sensor, 120x80, Logo, No Display, No Setpoint Adjust, Hardwired Terminals, 3% Humidity",{"$f":"'IOM Device'!D50","v":0}]
["I/O Module","IOM NS Sensor",{"$f":"VLOOKUP(D58,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"NS-BTN7001-0","Net Sensor, 120x80, JCI Logo, No Display, No Setpoint Adjust, Modular Jack, Address 199",{"$f":"'IOM Device'!D51","v":0}]
["I/O Module","IOM NS Sensor",{"$f":"VLOOKUP(D59,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"NS-BTN7001-2","Net Sensor, 120x80, No Logo, No Display, No Setpoint Adjust, Modular Jack, Address 199",{"$f":"'IOM Device'!D52","v":0}]
["I/O Module","IOM Wireless Receiver",{"$f":"VLOOKUP(D60,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-WRZ-7860-0"},"WRZ-7860-0","Wireless Receiver, One to Many Sensors ",{"$f":"'IOM Device'!D56","v":0},"Video Available!"]
["I/O Module","IOM Receiver Wire Extder",{"$f":"VLOOKUP(D61,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-ZFRCBLEXT-0"},"ZFR-CBLEXT-0","RJ12 Extension Cable 10\" for the WRZ-7860-0. ",{"$f":"'IOM Device'!D57","v":0}]
["I/O Module","IOM Wireless Sensor",{"$f":"VLOOKUP(D62,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-WRZSTR00000"},"WRZ-STR0000-0","Wireless Refrigerator/Freezer Temperature Transmitter",{"$f":"'IOM Device'!D58","v":0}]
["I/O Module","IOM Wireless Sensor",{"$f":"VLOOKUP(D63,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-WRZRMT10K-0"},"WRZ-RMT10K-0","Wireless Room Temperature Sensor Transmitter for Remote 10K Temperature Probes",{"$f":"'IOM Device'!D59","v":0}]
["I/O Module","IOM Wireless Sensor",{"$f":"VLOOKUP(D64,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"WRZ-TTR0000-0","Wireless Room Temperature Sensor Transmitter, No Setpoint Adjustment",{"$f":"'IOM Device'!D60","v":0}]
["I/O Module","IOM Wireless Sensor",{"$f":"VLOOKUP(D65,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-WRZTHN00000"},"WRZ-THN0000-0","Wireless Room Temperature and Humidity Sensor Transmitter ",{"$f":"'IOM Device'!D61","v":0}]
["I/O Module","IOM Energy Meter",{"$f":"VLOOKUP(D66,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'IOM Device - Energy Meter'!F33","v":"?"},{"$f":"VLOOKUP(D66,'Energy Meters'!A$1:B$38,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'IOM Device - Energy Meter'!G33","v":0},"Video Available!"]
["I/O Module","IOM Energy Meter",{"$f":"VLOOKUP(D67,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'IOM Device - Energy Meter'!F34","v":"?"},{"$f":"VLOOKUP(D67,'Energy Meters'!A$1:B$38,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'IOM Device - Energy Meter'!G34","v":0},"Video Available!"]
["I/O Module","IOM Energy Meter",{"$f":"VLOOKUP(D68,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'IOM Device - Energy Meter'!F35","v":"?"},{"$f":"VLOOKUP(D68,'Energy Meters'!A$1:B$38,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'IOM Device - Energy Meter'!G35","v":0},"Video Available!"]
["SZ - Smart Equipment","Zone Temperature",{"$f":"VLOOKUP(D69,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTB7003-0"},"NS-BTB7003-0","Netstat for Smart Equipment Single Zone Unit",{"$f":"'SZ - Smart Equipment'!D10","v":0}]
["SZ - Smart Equipment","Zone Temperature",{"$f":"VLOOKUP(D70,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTB7003-2"},"NS-BTB7003-2","Netstat for Smart Equipment Single Zone Unit",{"$f":"'SZ - Smart Equipment'!D11","v":0}]
["SZ - Smart Equipment","Zone Temperature",{"$f":"VLOOKUP(D71,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTN7003-0"},"NS-BTN7003-0","Netstat for Smart Equipment Single Zone Unit",{"$f":"'SZ - Smart Equipment'!D12","v":0}]
["SZ - Smart Equipment","Zone Temperature",{"$f":"VLOOKUP(D72,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTN7003-2"},"NS-BTN7003-2","Netstat for Smart Equipment Single Zone Unit",{"$f":"'SZ - Smart Equipment'!D13","v":0}]
["SZ - Smart Equipment","Zone Temperature",{"$f":"VLOOKUP(D73,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTP7002-0"},"NS-BTP7002-0","Netstat for Smart Equipment Single Zone Unit",{"$f":"'SZ - Smart Equipment'!D14","v":0}]
["SZ - Smart Equipment","Zone Temperature",{"$f":"VLOOKUP(D74,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTP7002-2"},"NS-BTP7002-2","Netstat for Smart Equipment Single Zone Unit",{"$f":"'SZ - Smart Equipment'!D15","v":0}]
["SZ - Smart Equipment","Zone Temperature",{"$f":"VLOOKUP(D75,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBHR7103-0"},"NS-BHR7103-0","Netstat for Smart Equipment Single Zone Unit",{"$f":"'SZ - Smart Equipment'!D16","v":0}]
["SZ - Smart Equipment","Zone Temperature",{"$f":"VLOOKUP(D76,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBHP7001-0"},"NS-BHP7001-0","Netstat for Smart Equipment Single Zone Unit",{"$f":"'SZ - Smart Equipment'!D17","v":0}]
["SZ - Smart Equipment","Zone Temperature",{"$f":"VLOOKUP(D77,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTB7F03-0"},"NS-BTB7F03-0","Netstat for Smart Equipment Single Zone Unit",{"$f":"'SZ - Smart Equipment'!D18","v":0}]
["SZ - Smart Equipment","Zone Temperature",{"$f":"VLOOKUP(D78,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTK7002-0"},"NS-BTK7002-0","Netstat for Smart Equipment Single Zone Unit",{"$f":"'SZ - Smart Equipment'!D19","v":0}]
["SZ - Smart Equipment","Zone Temperature",{"$f":"VLOOKUP(D79,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTK7002-2"},"NS-BTK7002-2","Netstat for Smart Equipment Single Zone Unit",{"$f":"'SZ - Smart Equipment'!D20","v":0}]
["SZ - Smart Equipment","CO2 Sensor",{"$f":"VLOOKUP(D80,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBCN7004-0"},"NS-BCN7004-0","BACnet network CO2 sensor 80 mm x 120 mm",{"$f":"'SZ - Smart Equipment'!D23","v":0}]
["SZ - Smart Equipment","COMM CARD",{"$f":"VLOOKUP(D81,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"SE-COM1001-0","Smart Equipment BACnet Communications Card",{"$f":"'SZ - Smart Equipment'!D28","v":0}]
["SZ - 3rd Party Units","Thermostat",{"$f":"VLOOKUP(D82,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3630-00"},"TEC3630-00-000","TSTAT, MSTP or N2, RTU/Heat pump with Econ, Logo",{"$f":"'SZ - 3rd Party Equipment'!I11","v":0},"Video Available!"]
["SZ - 3rd Party Units","Thermostat",{"$f":"VLOOKUP(D83,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3631-00"},"TEC3631-00-000","TSTAT, MSTP or N2, RTU/Heat pump with Econ, Occ sensor, Logo",{"$f":"'SZ - 3rd Party Equipment'!I12","v":0},"Video Available!"]
["SZ - 3rd Party Units","Thermostat",{"$f":"VLOOKUP(D84,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3630-01"},"TEC3630-01-000","TSTAT, MSTP or N2, RTU/Heat pump with Econ, No Logo",{"$f":"'SZ - 3rd Party Equipment'!I13","v":0},"Video Available!"]
["SZ - 3rd Party Units","Thermostat",{"$f":"VLOOKUP(D85,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3631-01"},"TEC3631-01-000","TSTAT, MSTP or N2, RTU/Heat pump with Econ, Occ sensor, No Logo",{"$f":"'SZ - 3rd Party Equipment'!I14","v":0},"Video Available!"]
["SZ - 3rd Party Units","Wireless Thermostat",{"$f":"VLOOKUP(D86,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30300000"},"TEC3030-00-000","TSTAT, MSTP or N2, RTU/Heat pump with Econ, Logo",{"$f":"'SZ - 3rd Party Equipment'!I19","v":0},"Video Available!"]
["SZ - 3rd Party Units","Wireless Thermostat",{"$f":"VLOOKUP(D87,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30310000"},"TEC3031-00-000","TSTAT, MSTP or N2, RTU/Heat pump with Econ, Occ sensor, Logo",{"$f":"'SZ - 3rd Party Equipment'!I20","v":0},"Video Available!"]
["SZ - 3rd Party Units","Wireless Thermostat",{"$f":"VLOOKUP(D88,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30300100"},"TEC3030-01-000","TSTAT, MSTP or N2, RTU/Heat pump with Econ, No Logo",{"$f":"'SZ - 3rd Party Equipment'!I21","v":0},"Video Available!"]
["SZ - 3rd Party Units","Wireless Thermostat",{"$f":"VLOOKUP(D89,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30310100"},"TEC3031-01-000","TSTAT, MSTP or N2, RTU/Heat pump with Econ, Occ sensor, No Logo",{"$f":"'SZ - 3rd Party Equipment'!I22","v":0},"Video Available!"]
["SZ - 3rd Party Units","Wireless Pro Coordinator",{"$f":"VLOOKUP(D90,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LCZFR1825-0"},"LC-ZFR1825-0","Wireless Coordinator and mounting base with 110/220 VAC power supply and antenna.",{"$f":"'SZ - 3rd Party Equipment'!I27","v":0},"Video Available!"]
["SZ - 3rd Party Units","Wireless Repeater Kit",{"$f":"VLOOKUP(D91,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LCZFR18210B"},"LC-ZFR1821-0B","Wireless Pro Repeater Kit with EMT mount, 3ft RJ-12 cable, and 24VAC to 15VDC power supply",{"$f":"'SZ - 3rd Party Equipment'!I30","v":0}]
["SZ - 3rd Party Units","Wireless Repeater Kit",{"$f":"VLOOKUP(D92,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LCZFR18220B"},"LC-ZFR1822-0B","Wireless Pro Repeater Wall Mount Kit, with 10ft RJ-12 cable and 24VAC to 15VDC power supply. ",{"$f":"'SZ - 3rd Party Equipment'!I31","v":0}]
["SZ - 3rd Party Units","Supply Temp",{"$f":"VLOOKUP(D93,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE-6311M-1"},"TE-6311M-1","8\" Duct Sensor Metal Enclosure, Nickel",{"$f":"'SZ - 3rd Party Equipment'!D36","v":0}]
["SZ - 3rd Party Units","Outside Temp",{"$f":"VLOOKUP(D94,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE-6313P-1"},"TE-6313P-1","Outside Air Sensor, Nickel",{"$f":"'SZ - 3rd Party Equipment'!D39","v":0}]
["SZ - 3rd Party Units","Remote Sensor",{"$f":"VLOOKUP(D95,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE68NT1N00S"},"TE-68NT-0N00S","Wall temperature sensor, 1k ohm, Nickel ",{"$f":"'SZ - 3rd Party Equipment'!D42","v":0}]
["SZ - 3rd Party Units","Wall plate",{"$f":"VLOOKUP(D96,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC-WALLPLT"},"TEC-WALLPLT","TEC3000 Wall Plate",{"$f":"'SZ - 3rd Party Equipment'!D52","v":0}]
["SZ - 3rd Party Units","Fan Status",{"$f":"VLOOKUP(D97,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-CSD-CF0A0-1"},"CSD-CF0A0-1","Current switch, Split Core, 0.15 A Fixed Switch Setpoint",{"$f":"'SZ - 3rd Party Equipment'!D45","v":0}]
["SZ - 3rd Party Units","Damper Actuator",{"$f":"VLOOKUP(D98,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-M9106-GGA-2"},"M9208-GGA-3","70in-lb spring return actuator proportional",{"$f":"'SZ - 3rd Party Equipment'!D48","v":0}]
["SZ - 3rd Party Units","Damper Actuator",{"$f":"VLOOKUP(D99,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-M9208-250"},"M9208-250","Remote mounting kit with crankarm and damper linkage. ",{"$f":"'SZ - 3rd Party Equipment'!D49","v":0}]
["MZ- Zone Coordinator","Zone Coordinator",{"$f":"VLOOKUP(D100,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LC-VZC100-0"},"LC-VZC100-0","Verasys Zoning Coordinator for VAV and COBP applications",{"$f":"'MZ- Zone Coordinator'!F10","v":0},"Video Available!"]
["MZ- Zone Coordinator","Zone Coordinator",{"$f":"VLOOKUP(D101,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LC-VZCPNL-0"},"LC-VZCPNL-0","Verasys Zoning Coordinator for VAV and COBP applications (Panel Version)",{"$f":"'MZ- Zone Coordinator'!F11","v":0},"Video Available!"]
["MZ- Zone Coordinator","Zone Power",{"$f":"VLOOKUP(D102,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-Y65T42-0"},"Y65T42-0","120/208/240 to 24V XFR 40VA (Power for 2 Boxes)",{"$f":"'MZ- Zone Coordinator'!F14","v":0}]
["MZ- Zone Coordinator","Zone Power",{"$f":"VLOOKUP(D103,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-PSH100A"},"PSH100A","120V to 24V XFR, 100VA (Power for 6 Boxes)",{"$f":"'MZ- Zone Coordinator'!F15","v":0}]
["MZ- Zone Coordinator","Zone Power",{"$f":"VLOOKUP(D104,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-PSH300A"},"PSH300A","480/277/240/120V to 24V XFR, 3 Circuits 100VA each (Power for 18 Boxes)",{"$f":"'MZ- Zone Coordinator'!F16","v":0}]
["MZ- Zone Coordinator","Zone Power",{"$f":"VLOOKUP(D105,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-PSH500A"},"PSH500A","480/277/240/120V  to 24V XFR,5 Circuits 100VA each (Power for 30 Boxes)",{"$f":"'MZ- Zone Coordinator'!F17","v":0}]
["MZ - Smart Equipment","COMM CARD",{"$f":"VLOOKUP(D106,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"SE-COM1001-0","Smart Equipment BACnet Communications Card",{"$f":"'MZ- Smart Equipment'!F12","v":0}]
["MZ- 3rd Party Units","3rd Party Controller",{"$f":"VLOOKUP(D107,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LC-VEC100-0"},"LC-VEC100-0","3rd Party RTU (VAV, COPB)",{"$f":"'MZ- 3rd Party Units'!F10","v":0},"Video Available!"]
["MZ- 3rd Party Units","Duct Sensors",{"$f":"VLOOKUP(D108,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE-6311M-1"},"TE-6311M-1","8\" Duct Sensor Metal Enclosure, Nickel",{"$f":"'MZ- 3rd Party Units'!F14","v":0}]
["MZ- 3rd Party Units","Static Pressure Sensor",{"$f":"VLOOKUP(D109,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-DPT2640005D"},"DPT2640-005D","Low Differential Pressure Transducer 0-5 in WC, 0-5VDC",{"$f":"'MZ- 3rd Party Units'!F17","v":0}]
["MZ- 3rd Party Units","Static Pressure Probe",{"$f":"VLOOKUP(D110,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-FTG18A-600R"},"FTG18A-600R","Duct Static Pressure Probe (Need 1 Per Sensor)",{"$f":"'MZ- 3rd Party Units'!F18","v":0}]
["MZ- 3rd Party Units","Outside Temp",{"$f":"VLOOKUP(D111,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE-6313P-1"},"TE-6313P-1","Outside Air Sensor, Nickel",{"$f":"'MZ- 3rd Party Units'!F21","v":0}]
["MZ- 3rd Party Units","Filter Status",{"$f":"VLOOKUP(D112,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-P32AC-2C"},"P32AC-2C","Differential Pressure Switch, Single-Pole, Double-Throw (SPDT)",{"$f":"'MZ- 3rd Party Units'!F24","v":0}]
["MZ- 3rd Party Units","Filter Status",{"$f":"VLOOKUP(D113,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-FTG18A-600R"},"FTG18A-600R","Duct Static Pressure Probe Kit: 4 in. Flanged Sensing Tube",{"$f":"'MZ- 3rd Party Units'!F25","v":0}]
["MZ- 3rd Party Units","Fan Status",{"$f":"VLOOKUP(D114,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-CSD-CF0A0-1"},"CSD-CF0A0-1","Current switch, Split Core, 0.15 A Fixed Switch Setpoint",{"$f":"'MZ- 3rd Party Units'!F28","v":0}]
["MZ- 3rd Party Units","Return CO2 Sensor",{"$f":"VLOOKUP(D115,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"CD-P1000-00-00","Duct Mount CO2 Transmitter 0–10 VDC, 0–2,000 ppm CO2",{"$f":"'MZ- 3rd Party Units'!F31","v":0}]
["MZ- 3rd Party Units","Zone Humidity",{"$f":"VLOOKUP(D116,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBHN7003-0"},"NS-BHN7003-0","Netstat, 3% Humidity, addressable",{"$f":"'MZ- 3rd Party Units'!F34","v":0}]
["MZ- 3rd Party Units","Damper Actuator",{"$f":"VLOOKUP(D117,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-M9106-GGA-2"},"M9208-GGA-3","70in-lb spring return actuator proportional",{"$f":"'MZ- 3rd Party Units'!F37","v":0}]
["MZ- 3rd Party Units","Damper Actuator",{"$f":"VLOOKUP(D118,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-M9208-250"},"M9208-250","Remote mounting kit with crankarm and damper linkage. ",{"$f":"'MZ- 3rd Party Units'!F38","v":0}]
["MZ- VAV Zones","Controller",{"$f":"VLOOKUP(D119,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LC-ZEC410-1"},"LC-ZEC410-1","Configurable VAV Box Controller, All Fan Types, Stg Box Htg",{"$f":"'MZ- VAV Zones'!E10","v":0},"Video Available!"]
["MZ- VAV Zones","Controller",{"$f":"VLOOKUP(D120,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LC-ZEC410-2"},"LC-ZEC410-2","Configurable VAV Box Controller, All Fan Types, Inc Box Htg",{"$f":"'MZ- VAV Zones'!E11","v":0},"Video Available!"]
["MZ- VAV Zones","Controller",{"$f":"VLOOKUP(D121,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LC-ZEC410-3"},"LC-ZEC410-3","Configurable VAV Box Controller, All Fan Types, Prop(SCR) Box Htg",{"$f":"'MZ- VAV Zones'!E12","v":0},"Video Available!"]
["MZ- VAV Zones","Zone Temperature",{"$f":"VLOOKUP(D122,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTB7003-0"},"NS-BTB7003-0","Net Sensor, 120x80, JCI Logo, Local Setpoint, Terminals",{"$f":"'MZ- VAV Zones'!E15","v":0}]
["MZ- VAV Zones","Zone Temperature",{"$f":"VLOOKUP(D123,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTB7003-2"},"NS-BTB7003-2","Net Sensor, 120x80, No Logo, Local Setpoint, Terminals",{"$f":"'MZ- VAV Zones'!E16","v":0}]
["MZ- VAV Zones","Zone Temperature",{"$f":"VLOOKUP(D124,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTN7003-0"},"NS-BTN7003-0","Net Sensor, 120x80, JCI Logo, No Setpoint, Terminals",{"$f":"'MZ- VAV Zones'!E17","v":0}]
["MZ- VAV Zones","Zone Temperature",{"$f":"VLOOKUP(D125,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTN7003-2"},"NS-BTN7003-2","Net Sensor, 120x80, No Logo, No Setpoint, Terminals",{"$f":"'MZ- VAV Zones'!E18","v":0}]
["MZ- VAV Zones","Zone Temperature",{"$f":"VLOOKUP(D126,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTP7002-0"},"NS-BTP7002-0","Net Sensor, 120x80, JCI Logo, Warmer/Cooler Adjustment, Terminals",{"$f":"'MZ- VAV Zones'!E19","v":0}]
["MZ- VAV Zones","Zone Temperature",{"$f":"VLOOKUP(D127,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTP7002-2"},"NS-BTP7002-2","Net Sensor, 120x80, No Logo, Warmer/Cooler Adjustment, Terminals",{"$f":"'MZ- VAV Zones'!E20","v":0}]
["MZ- VAV Zones","Zone Temperature",{"$f":"VLOOKUP(D128,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTK7002-0"},"NS-BTK7002-0","Netstat for Smart Equipment Single Zone Unit",{"$f":"'MZ- VAV Zones'!E21","v":0}]
["MZ- VAV Zones","Zone Temperature",{"$f":"VLOOKUP(D129,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTK7002-2"},"NS-BTK7002-2","Netstat for Smart Equipment Single Zone Unit",{"$f":"'MZ- VAV Zones'!E22","v":0}]
["MZ- VAV Zones","Discharge Temp",{"$f":"VLOOKUP(D130,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE631GV-2"},"TE-631GV-2","4\" Duct Sensor for VAV Flange Mount, Nickel, 10ft plenum Cable",{"$f":"'MZ- VAV Zones'!E25","v":0}]
["MZ- VAV Zones","CO2 Sensor",{"$f":"VLOOKUP(D131,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBCN7004-0"},"NS-BCN7004-0","BACnet network CO2 sensor 80 mm x 120 mm",{"$f":"'MZ- VAV Zones'!E28","v":0}]
["MZ- VAV Zones","Occupancy Lighting",{"$f":"VLOOKUP(D132,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-OLS-2100-1"},"OLS-2100-1","Occupancy Lighting Switch",{"$f":"'MZ- VAV Zones'!E31","v":0}]
["MZ- VAV Zones","Occupancy Lighting",{"$f":"VLOOKUP(D133,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RIBU1C"},"RIBU1C","Enclosed relay for OLS-2100-1 sensor",{"$f":"'MZ- VAV Zones'!E32","v":0}]
["MZ- VAV Zones","Balancing",{"$f":"VLOOKUP(D134,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSATV7003-0"},"NS-ATV7003-0","VAV Box Balancing Thermostat",{"$f":"'MZ- VAV Zones'!E35","v":0}]
["MZ - COBP Zones","Zone Temperature",{"$f":"VLOOKUP(D135,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTB7003-0"},"NS-BTB7003-0","Net Sensor, 120x80, JCI Logo, Local Setpoint, Terminals",{"$f":"'MZ - COBP Zones'!F45","v":0}]
["MZ - COBP Zones","Zone Temperature",{"$f":"VLOOKUP(D136,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTB7003-2"},"NS-BTB7003-2","Net Sensor, 120x80, No Logo, Local Setpoint, Terminals",{"$f":"'MZ - COBP Zones'!F46","v":0}]
["MZ - COBP Zones","Zone Temperature",{"$f":"VLOOKUP(D137,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTN7003-0"},"NS-BTN7003-0","Net Sensor, 120x80, JCI Logo, No Setpoint, Terminals",{"$f":"'MZ - COBP Zones'!F47","v":0}]
["MZ - COBP Zones","Zone Temperature",{"$f":"VLOOKUP(D138,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTN7003-2"},"NS-BTN7003-2","Net Sensor, 120x80, No Logo, No Setpoint, Terminals",{"$f":"'MZ - COBP Zones'!F48","v":0}]
["MZ - COBP Zones","Zone Temperature",{"$f":"VLOOKUP(D139,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTP7002-0"},"NS-BTP7002-0","Net Sensor, 120x80, JCI Logo, Warmer/Cooler Adjustment, Terminals",{"$f":"'MZ - COBP Zones'!F49","v":0}]
["MZ - COBP Zones","Zone Temperature",{"$f":"VLOOKUP(D140,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTP7002-2"},"NS-BTP7002-2","Net Sensor, 120x80, No Logo, Warmer/Cooler Adjustment, Terminals",{"$f":"'MZ - COBP Zones'!F50","v":0}]
["MZ - COBP Zones","Zone Temperature",{"$f":"VLOOKUP(D141,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTK7002-0"},"NS-BTK7002-0","Netstat for Smart Equipment Single Zone Unit",{"$f":"'MZ - COBP Zones'!F51","v":0}]
["MZ - COBP Zones","Zone Temperature",{"$f":"VLOOKUP(D142,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTK7002-2"},"NS-BTK7002-2","Netstat for Smart Equipment Single Zone Unit",{"$f":"'MZ - COBP Zones'!F52","v":0}]
["MZ - COBP Zones","Zone Temperature",{"$f":"VLOOKUP(D143,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE68NT1N00S"},"TE-68NT-0N00S","Wall temperature sensor, 1k ohm, nickel with temperature occupancy button.",{"$f":"'MZ - COBP Zones'!F41","v":0}]
["MZ - COBP Zones","Zone Temperature",{"$f":"VLOOKUP(D144,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE68NT1N00S"},"TE-68NT-1N00S","Wall temperature sensor, 1k ohm,nickel with warmer/cooler (W/C) adjustment and temperature occupancy pushbutton.",{"$f":"'MZ - COBP Zones'!F42","v":0}]
["MZ - COBP Zones","CO2 Sensor",{"$f":"VLOOKUP(D145,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBCN7004-0"},"NS-BCN7004-0","BACnet network CO2 sensor 80 mm x 120 mm",{"$f":"'MZ - COBP Zones'!F59","v":0}]
["MZ - COBP Zones","Controller",{"$f":"VLOOKUP(D146,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LC-ZEC310-0"},"LC-ZEC310-0","Field Installed, Zone Damper Controller No Damper",{"$f":"'MZ - COBP Zones'!F10","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D147,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG04B","4\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F11","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D148,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG06B","6\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F12","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D149,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG07B","7\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F13","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D150,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG08B","8\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F14","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D151,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG09B","9\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F15","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D152,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG10B","10\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F16","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D153,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG11B","11\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F17","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D154,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG12B","12\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F18","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D155,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG13B","13\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F19","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D156,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG14B","14\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F20","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D157,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG15B","15\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F21","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D158,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG16B","16\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F22","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D159,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG17B","17\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F23","v":0}]
["MZ - COBP Zones","Zone Damper",{"$f":"VLOOKUP(D160,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG18B","18\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ - COBP Zones'!F24","v":0}]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D161,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV06Z"},"RZV06Z","6\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F25","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D162,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV07Z"},"RZV07Z","7\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F26","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D163,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV08Z"},"RZV08Z","8\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F27","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D164,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV09Z"},"RZV09Z","9\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F28","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D165,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV10Z"},"RZV10Z","10\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F29","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D166,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV11Z"},"RZV11Z","11\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F30","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D167,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV12Z"},"RZV12Z","12\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F31","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D168,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV13Z"},"RZV13Z","13\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F32","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D169,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV14Z"},"RZV14Z","14\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F33","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D170,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV15Z"},"RZV15Z","15\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F34","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D171,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV16Z"},"RZV16Z","16\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F35","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D172,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV17Z"},"RZV17Z","17\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F36","v":0},"Video Available!"]
["MZ - COBP Zones","Zone Damper/Controller",{"$f":"VLOOKUP(D173,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV18Z"},"RZV18Z","18\" Round Zone Damper LC-ZEC310-0 Controller ",{"$f":"'MZ - COBP Zones'!F37","v":0},"Video Available!"]
["MZ - COBP Zones","Occupancy Lighting",{"$f":"VLOOKUP(D174,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-OLS-2100-1"},"OLS-2100-1","Occupancy Lighting Switch",{"$f":"'MZ - COBP Zones'!F55","v":0}]
["MZ - COBP Zones","Occupancy Lighting",{"$f":"VLOOKUP(D175,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RIBU1C"},"RIBU1C","Enclosed relay for OLS-2100-1 sensor",{"$f":"'MZ - COBP Zones'!F56","v":0}]
["MZ - COBP Zones","Second Zone Damper",{"$f":"VLOOKUP(D176,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"M9310-HGA-2","10NM Torque Non-Spring Return Damper Actuator",{"$f":"'MZ - COBP Zones'!F62","v":0}]
["MZ- Bypass Damper","Controller",{"$f":"VLOOKUP(D177,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LC-BYP200-0"},"LC-BYP200-0","Field Installed, Bypass Damper Controller No Damper",{"$f":"'MZ- Bypass Damper'!F10","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D178,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG06B","6\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F11","v":0}]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D179,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG07B","7\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F12","v":0}]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D180,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG08B","8\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F13","v":0}]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D181,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG09B","9\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F14","v":0}]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D182,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG10B","10\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F15","v":0}]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D183,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG11B","11\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F16","v":0}]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D184,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG12B","12\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F17","v":0}]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D185,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG13B","13\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F18","v":0}]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D186,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG14B","14\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F19","v":0}]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D187,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG15B","15\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F20","v":0}]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D188,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG16B","16\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F21","v":0}]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D189,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG17B","17\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F22","v":0}]
["MZ- Bypass Damper","Bypass Damper",{"$f":"VLOOKUP(D190,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"RCG18B","18\" Round Zone/Bypass Damper No Controller ",{"$f":"'MZ- Bypass Damper'!F23","v":0}]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D191,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV06Y"},"RZV06Y","6\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F24","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D192,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV07Y"},"RZV07Y","7\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F25","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D193,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV08Y"},"RZV08Y","8\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F26","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D194,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV09Y"},"RZV09Y","9\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F27","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D195,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV10Y"},"RZV10Y","10\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F28","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D196,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV11Y"},"RZV11Y","11\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F29","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D197,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV12Y"},"RZV12Y","12\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F30","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D198,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV13Y"},"RZV13Y","13\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F31","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D199,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV14Y"},"RZV14Y","14\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F32","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D200,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV15Y"},"RZV15Y","15\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F33","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D201,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV16Y"},"RZV16Y","16\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F34","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D202,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV17Y"},"RZV17Y","17\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F35","v":0},"Video Available!"]
["MZ- Bypass Damper","Bypass Damper/Controller",{"$f":"VLOOKUP(D203,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RZV18Y"},"RZV18Y","18\" Round Bypass Damper LC-BYP200-0 Controller",{"$f":"'MZ- Bypass Damper'!F36","v":0},"Video Available!"]
["MZ- Bypass Damper","Static Pressure Sensor",{"$f":"VLOOKUP(D204,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-DPT2640005D"},"DPT2640-005D","Low Differential Pressure Transducer 0-5 in WC, 0-5VDC",{"$f":"'MZ- Bypass Damper'!F41","v":0}]
["MZ- Bypass Damper","Static Pressure Probe",{"$f":"VLOOKUP(D205,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-FTG18A-600R"},"FTG18A-600R","Duct Static Pressure Probe (Need 1 Per Sensor)",{"$f":"'MZ- Bypass Damper'!F42","v":0}]
["MZ- Bypass Damper","Bypass Power",{"$f":"VLOOKUP(D206,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-Y65T42-0"},"Y65T42-0","120/208/240 to 24V XFR 40VA (Power for 2 Boxes)",{"$f":"'MZ- Bypass Damper'!F45","v":0}]
["MZ- Bypass Damper","Second Bypass Damper",{"$f":"VLOOKUP(D207,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"M9310-HGA-2","10NM Torque Non-Spring Return Damper Actuator",{"$f":"'MZ- Bypass Damper'!F49","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D208,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3610-00"},"TEC3610-00-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, Logo",{"$f":"'Fan Coil Units'!H10","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D209,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3611-00"},"TEC3611-00-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, Occ sensor, Logo",{"$f":"'Fan Coil Units'!H11","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D210,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3612-00"},"TEC3612-00-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, RH sensor, Logo",{"$f":"'Fan Coil Units'!H12","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D211,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3613-00"},"TEC3613-00-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, Occ & RH sensor, Logo",{"$f":"'Fan Coil Units'!H13","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D212,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3620-00"},"TEC3620-00-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, Logo",{"$f":"'Fan Coil Units'!H14","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D213,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3621-00"},"TEC3621-00-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, Occ sensor, Logo",{"$f":"'Fan Coil Units'!H15","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D214,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3622-00"},"TEC3622-00-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, RH sensor, Logo",{"$f":"'Fan Coil Units'!H16","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D215,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3623-00"},"TEC3623-00-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, Occ & RH sensor, Logo",{"$f":"'Fan Coil Units'!H17","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D216,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3610-01"},"TEC3610-01-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, No Logo",{"$f":"'Fan Coil Units'!H18","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D217,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3611-01"},"TEC3611-01-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, Occ sensor, No Logo",{"$f":"'Fan Coil Units'!H19","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D218,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3612-01"},"TEC3612-01-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, RH sensor, No Logo",{"$f":"'Fan Coil Units'!H20","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D219,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3613-01"},"TEC3613-01-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, Occ & RH sensor, No Logo",{"$f":"'Fan Coil Units'!H21","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D220,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3620-01"},"TEC3620-01-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, No Logo",{"$f":"'Fan Coil Units'!H22","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D221,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3621-01"},"TEC3621-01-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, Occ sensor, No Logo",{"$f":"'Fan Coil Units'!H23","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D222,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3622-01"},"TEC3622-01-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, RH sensor, No Logo",{"$f":"'Fan Coil Units'!H24","v":0}]
["Fan Coil Units","Thermostat",{"$f":"VLOOKUP(D223,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC3623-01"},"TEC3623-01-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, Occ & RH sensor, No Logo",{"$f":"'Fan Coil Units'!H25","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D224,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30100000"},"TEC3010-00-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, Logo",{"$f":"'Fan Coil Units'!H29","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D225,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30110000"},"TEC3011-00-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, Occ sensor, Logo",{"$f":"'Fan Coil Units'!H30","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D226,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30120000"},"TEC3012-00-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, RH sensor, Logo",{"$f":"'Fan Coil Units'!H31","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D227,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30130000"},"TEC3013-00-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, Occ & RH sensor, Logo",{"$f":"'Fan Coil Units'!H32","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D228,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30200000"},"TEC3020-00-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, Logo",{"$f":"'Fan Coil Units'!H33","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D229,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30210000"},"TEC3021-00-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, Occ sensor, Logo",{"$f":"'Fan Coil Units'!H34","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D230,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30220000"},"TEC3022-00-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, RH sensor, Logo",{"$f":"'Fan Coil Units'!H35","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D231,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30230000"},"TEC3023-00-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, Occ & RH sensor, Logo",{"$f":"'Fan Coil Units'!H36","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D232,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30100100"},"TEC3010-01-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, No Logo",{"$f":"'Fan Coil Units'!H37","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D233,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30110100"},"TEC3011-01-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, Occ sensor, No Logo",{"$f":"'Fan Coil Units'!H38","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D234,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30120100"},"TEC3012-01-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, RH sensor, No Logo",{"$f":"'Fan Coil Units'!H39","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D235,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30130100"},"TEC3013-01-000","TSTAT, MSTP or N2, FCU/VVT, On/Off or floating, Occ & RH sensor, No Logo",{"$f":"'Fan Coil Units'!H40","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D236,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30200100"},"TEC3020-01-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, No Logo",{"$f":"'Fan Coil Units'!H41","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D237,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30210100"},"TEC3021-01-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, Occ sensor, No Logo",{"$f":"'Fan Coil Units'!H42","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D238,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30220100"},"TEC3022-01-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, RH sensor, No Logo",{"$f":"'Fan Coil Units'!H43","v":0}]
["Fan Coil Units","Wireless Thermostat",{"$f":"VLOOKUP(D239,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC30230100"},"TEC3023-01-000","TSTAT, MSTP or N2, FCU/VVT, 0-10VDC prop, Occ & RH sensor, No Logo",{"$f":"'Fan Coil Units'!H44","v":0}]
["Fan Coil Units","Supply Temp",{"$f":"VLOOKUP(D240,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE-6311M-1"},"TE-6311M-1","8\" Duct Sensor Metal Enclosure, Nickel",{"$f":"'Fan Coil Units'!D58","v":0}]
["Fan Coil Units","Remote Sensor",{"$f":"VLOOKUP(D241,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE68NT1N00S"},"TE-68NT-0N00S","Wall temperature sensor, 1k ohm, Nickel ",{"$f":"'Fan Coil Units'!D61","v":0}]
["Fan Coil Units","Fan Status",{"$f":"VLOOKUP(D242,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-CSD-CF0A0-1"},"CSD-CF0A0-1","Current switch, Split Core, 0.15 A Fixed Switch Setpoint",{"$f":"'Fan Coil Units'!D64","v":0}]
["Fan Coil Units","Wall plate",{"$f":"VLOOKUP(D243,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TEC-WALLPLT"},"TEC-WALLPLT","TEC3000 Wall Plate",{"$f":"'Fan Coil Units'!D67","v":0}]
["Fan Coil Units","Wireless Pro Coordinator",{"$f":"VLOOKUP(D244,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LCZFR1825-0"},"LC-ZFR1825-0","Wireless Coordinator and mounting base with 110/220 VAC power supply and antenna.",{"$f":"'Fan Coil Units'!G49","v":0},"Video Available!"]
["Fan Coil Units","Wireless Repeater Kit",{"$f":"VLOOKUP(D245,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LCZFR18210B"},"LC-ZFR1821-0B","Wireless Pro Repeater Kit with EMT mount, 3ft RJ-12 cable, and 24VAC to 15VDC power supply",{"$f":"'Fan Coil Units'!G52","v":0}]
["Fan Coil Units","Wireless Repeater Kit",{"$f":"VLOOKUP(D246,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LCZFR18220B"},"LC-ZFR1822-0B","Wireless Pro Repeater Wall Mount Kit, with 10ft RJ-12 cable and 24VAC to 15VDC power supply. ",{"$f":"'Fan Coil Units'!G53","v":0}]
["Advanced Application","Application Controller",{"$f":"VLOOKUP(D247,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LCVAC1000-0"},"LC-VAC1000-0","18 Point 24v, Application Controller with no application loaded",{"$f":"'Adv. Application Controller'!G11","v":0},"Video Available!"]
["Advanced Application","Application Controller",{"$f":"VLOOKUP(D248,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LCVAC3000-0"},"LC-VAC3000-0","32 Point 24v, Application Controller with no application loaded",{"$f":"'Adv. Application Controller'!G12","v":0},"Video Available!"]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D249,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE-6311M-1"},"TE-6311M-1","8\" Duct Sensor Metal Enclosure, Nickel ",{"$f":"'Adv. Application Controller'!G17","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D250,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"TE-6315M-1","8\" Duct Sensor Metal Enclosure, Nickel",{"$f":"'Adv. Application Controller'!G20","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D251,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-TE-6313P-1"},"TE-6313P-1","Outside Air Sensor, Nickel",{"$f":"'Adv. Application Controller'!G23","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D252,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-CSDECMC35200L0"},"CSDECM-C35200L0","Current switch, Split Core, 0.15 A Fixed Switch Setpoint 0.15 to 200 A Range",{"$f":"'Adv. Application Controller'!G26","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D253,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"A70HA-1C","Two Circuit Temp Control",{"$f":"'Adv. Application Controller'!G29","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D254,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"TE-6001-8","Mounting Bracket intended to maintain the minimum bend radius for sensors",{"$f":"'Adv. Application Controller'!G30","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D255,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-OLS-2100-1"},"OLS-2100-1","Occupancy Light Switch with infrared sensor",{"$f":"'Adv. Application Controller'!G33","v":0}]
["Advanced Application","Application Relay",{"$f":"VLOOKUP(D256,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RIBU1C"},"RIBU1C","Enclosed Relay SPDT (10A), 10-30VAC/DC",{"$f":"'Adv. Application Controller'!G34","v":0}]
["Advanced Application","Application Actuator",{"$f":"VLOOKUP(D257,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-M9106-GGA-2"},"M9208-GGA-3","70in-lb spring return actuator proportional",{"$f":"'Adv. Application Controller'!G37","v":0}]
["Advanced Application","Application Actuator",{"$f":"VLOOKUP(D258,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-M9208-250"},"M9208-250","Remote mounting kit with crankarm and damper linkage. ",{"$f":"'Adv. Application Controller'!G38","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D259,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTB7003-0"},"NS-BTB7003-0","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G43","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D260,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTB7003-2"},"NS-BTB7003-2","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G44","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D261,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTN7003-0"},"NS-BTN7003-0","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G45","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D262,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTN7003-2"},"NS-BTN7003-2","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G46","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D263,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTP7002-0"},"NS-BTP7002-0","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G47","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D264,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTP7002-2"},"NS-BTP7002-2","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G48","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D265,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"NS-BTJ7002-0","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G49","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D266,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"NS-BTJ7002-2","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G50","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D267,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBHR7103-0"},"NS-BHR7103-0","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G54","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D268,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBHN7003-0"},"NS-BHN7003-0","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G55","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D269,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"NS-BHP7003-0","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G56","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D270,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"NS-BHM7103-2","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G57","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D271,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBTB7F03-0"},"NS-BTB7F03-0","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G61","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D272,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-NSBCN7004-0"},"NS-BCN7004-0","Netstat for Application Controller",{"$f":"'Adv. Application Controller'!G65","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D273,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-H67N30N00P"},"HE-67N3-0N00P","Duct Humidity Sensor w Temp Sensor (3%)",{"$f":"'Adv. Application Controller'!G70","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D274,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"CD-P1000-00-00","Duct Mount CO2 Transmitter 0–10 VDC, 0–2,000 ppm CO2",{"$f":"'Adv. Application Controller'!G71","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D275,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-P32AC-2C"},"P32AC-2C","Differential Pressure Switch, Single-Pole, Double-Throw (SPDT)",{"$f":"'Adv. Application Controller'!G74","v":0}]
["Advanced Application","Application I/O",{"$f":"VLOOKUP(D276,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-FTG18A-600R"},"FTG18A-600R","Duct Static Pressure Probe (Need 1 Per Sensor)",{"$f":"'Adv. Application Controller'!G75","v":0}]
["Lighting System","Lighting Controller",{"$f":"VLOOKUP(D277,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-LCVAC1001-0"},"LC-VAC1001-0","18 Point 24v, Application Controller with Lighting Application",{"$f":"Lighting!G11","v":0},"Video Available!"]
["Lighting System","Lighting Sensor",{"$f":"VLOOKUP(D278,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"MK7-B-CR-VTI","Outdoor Light Level Sensor, 0-250 Ft Candles",{"$f":"Lighting!G16","v":0}]
["Lighting System","Lighting Sensor",{"$f":"VLOOKUP(D279,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":{"$error":"#N/A"}},"MK7-B-CCF-VTI","Indoor Light Level Sensor, 0-100 Ft Candles",{"$f":"Lighting!G17","v":0}]
["Lighting System","Lighting Sensor",{"$f":"VLOOKUP(D280,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-OLS-2100-1"},"OLS-2100-1","Occupancy Lighting Switch",{"$f":"Lighting!G20","v":0}]
["Lighting System","Lighting Sensor",{"$f":"VLOOKUP(D281,'Source 1 Parts Ref'!A$2:B$239,2,FALSE)","v":"S1-RIBU1C"},"RIBU1C","Enclosed relay for OLS-2100-1 sensor",{"$f":"Lighting!G21","v":0}]

{"sheet":"Pricing","index":16,"n_rows":284,"n_cols":7,"rows_kept":284,"cut":false,"hidden":true,"merged":[[13,0,13,6],[11,4,11,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"List Grand Total:",null,{"$f":"SUM(G16:G281)","v":0}]
[]
["Bill of Materials"]
["System","Function",null,"JCI Part No","List Price","Qty","Total (List * Qty) USD"]
["Network","Smart Building Hub",null,"LC-SBH200-0",{"$f":"VLOOKUP(D16,'AOMS List Price'!A$2:B$243,2, FALSE)","v":1853.49},{"$f":"BOM!F13","v":0},{"$f":"E16*F16","v":0}]
["Network","Smart Building Hub Power",null,"ACC-PWRKIT-1A24",{"$f":"VLOOKUP(D17,'AOMS List Price'!A$2:B$243,2, FALSE)","v":154.36000000000001},{"$f":"BOM!F14","v":0},{"$f":"E17*F17","v":0}]
["Network","Smart Building Hub WiFi",null,"ACC-WIFIKIT-ODU",{"$f":"VLOOKUP(D18,'AOMS List Price'!A$2:B$243,2, FALSE)","v":178.68},{"$f":"BOM!F15","v":0},0]
["Network","BACnet MSTP Repeater",null,"4683-TTM-3F",{"$f":"VLOOKUP(D19,'AOMS List Price'!A$2:B$243,2, FALSE)","v":872.96},{"$f":"BOM!F16","v":0},0]
["Network","BACnet MSTP EOL",null,"MS-BACEOL-0",{"$f":"VLOOKUP(D20,'AOMS List Price'!A$2:B$243,2, FALSE)","v":115.21},{"$f":"BOM!F17","v":0},0]
["Network","Communication Wire",null,"CBL-22/3-FC-PLN",{"$f":"VLOOKUP(D21,'AOMS List Price'!A$2:B$243,2, FALSE)","v":0.3},{"$f":"BOM!F18","v":0},0]
["Network","Communication Wire",null,"CBL-22/3-FC-PVC ",{"$f":"VLOOKUP(D22,'AOMS List Price'!A$2:B$243,2, FALSE)","v":0.36},{"$f":"BOM!F19","v":0},0]
["Network","Communication Wire",null,"CBL-22/2P-SAPLN",{"$f":"VLOOKUP(D23,'AOMS List Price'!A$2:B$243,2, FALSE)","v":0.68},{"$f":"BOM!F20","v":0},0]
["Network","Communication Wire",null,"CBL-22/2P-SAPVC",{"$f":"VLOOKUP(D24,'AOMS List Price'!A$2:B$243,2, FALSE)","v":0.56000000000000005},{"$f":"BOM!F21","v":0},0]
["Network","Battery Backup",null,"UPSPNL550-0",{"$f":"VLOOKUP(D25,'AOMS List Price'!A$2:B$243,2, FALSE)","v":930.32},{"$f":"BOM!F22","v":0},0]
["I/O Module","IOM Device",null,"LC-VAC1002-0",{"$f":"VLOOKUP(D26,'AOMS List Price'!A$2:B$243,2, FALSE)","v":665.3},{"$f":"BOM!F23","v":0},0]
["I/O Module","IOM Panel",null,"PA0000004GC0",{"$f":"VLOOKUP(D27,'AOMS List Price'!A$2:B$243,2, FALSE)","v":773.22},{"$f":"BOM!F24","v":0},0]
["I/O Module","IOM Panel",null,"PA0000001AH0",{"$f":"VLOOKUP(D28,'AOMS List Price'!A$2:B$243,2, FALSE)","v":806.43},{"$f":"BOM!F25","v":0},0]
["I/O Module","IOM Panel",null,"PA0000001EH0",{"$f":"VLOOKUP(D29,'AOMS List Price'!A$2:B$243,2, FALSE)","v":879.77},{"$f":"BOM!F26","v":0},0]
["I/O Module","IOM Transformer",null,"Y65T42-0",{"$f":"VLOOKUP(D30,'AOMS List Price'!A$2:B$243,2, FALSE)","v":76.63},{"$f":"BOM!F27","v":0},0]
["I/O Module","I/O",null,"TE-68NT-0N00S",{"$f":"VLOOKUP(D31,'AOMS List Price'!A$2:B$243,2, FALSE)","v":95.95},{"$f":"BOM!F28","v":0},0]
["I/O Module","I/O",null,"TE-6311M-1",{"$f":"VLOOKUP(D32,'AOMS List Price'!A$2:B$243,2, FALSE)","v":35.630000000000003},{"$f":"BOM!F29","v":0},0]
["I/O Module","I/O",null,"TE-6313P-1",{"$f":"VLOOKUP(D33,'AOMS List Price'!A$2:B$243,2, FALSE)","v":51.47},{"$f":"BOM!F30","v":0},0]
["I/O Module","I/O",null,"HE-68N3-0N00WS",{"$f":"VLOOKUP(D34,'AOMS List Price'!A$2:B$243,2, FALSE)","v":523.74},{"$f":"BOM!F31","v":0},0]
["I/O Module","I/O",null,"HE-68P3-0N000",{"$f":"VLOOKUP(D35,'AOMS List Price'!A$2:B$243,2, FALSE)","v":1378.11},{"$f":"BOM!F32","v":0},0]
["I/O Module","I/O",null,"HE-67N3-0N00P",{"$f":"VLOOKUP(D36,'AOMS List Price'!A$2:B$243,2, FALSE)","v":469.4},{"$f":"BOM!F33","v":0},0]
["I/O Module","I/O",null,"CD-W00-00-2",{"$f":"VLOOKUP(D37,'AOMS List Price'!A$2:B$243,2, FALSE)","v":515},{"$f":"BOM!F34","v":0},0]
["I/O Module","I/O",null,"2020-T",{"$f":"VLOOKUP(D38,'AOMS List Price'!A$2:B$243,2, FALSE)","v":9.39},{"$f":"BOM!F35","v":0},0]
["I/O Module","I/O",null,"2505A",{"$f":"VLOOKUP(D39,'AOMS List Price'!A$2:B$243,2, FALSE)","v":91.37},{"$f":"BOM!F36","v":0},0]
["I/O Module","I/O",null,"MK7-B-CR-VTI",{"$f":"VLOOKUP(D40,'AOMS List Price'!A$2:B$243,2, FALSE)","v":551.61},{"$f":"BOM!F37","v":0},0]
["I/O Module","I/O",null,"DPT2090-25G",{"$f":"VLOOKUP(D41,'AOMS List Price'!A$2:B$243,2, FALSE)","v":356},{"$f":"BOM!F38","v":0},0]
["I/O Module","I/O",null,"TBG16A-600R",{"$f":"VLOOKUP(D42,'AOMS List Price'!A$2:B$243,2, FALSE)","v":50.51},{"$f":"BOM!F39","v":0},0]
["I/O Module","I/O",null,"DPT2640-0R1B",{"$f":"VLOOKUP(D43,'AOMS List Price'!A$2:B$243,2, FALSE)","v":333.24},{"$f":"BOM!F40","v":0},0]
["I/O Module","I/O",null,"DPT2640-R25D",{"$f":"VLOOKUP(D44,'AOMS List Price'!A$2:B$243,2, FALSE)","v":333.24},{"$f":"BOM!F41","v":0},0]
["I/O Module","I/O",null,"A-306-K",{"$f":"VLOOKUP(D45,'AOMS List Price'!A$2:B$243,2, FALSE)","v":119.68},{"$f":"BOM!F42","v":0},0]
["I/O Module","I/O",null,"SD-01",{"$f":"VLOOKUP(D46,'AOMS List Price'!A$2:B$243,2, FALSE)","v":101.85},{"$f":"BOM!F43","v":0},0]
["I/O Module","I/O",null,"RPS",{"$f":"VLOOKUP(D47,'AOMS List Price'!A$2:B$243,2, FALSE)","v":39.92},{"$f":"BOM!F44","v":0},0]
["I/O Module","I/O",null,"RPS-W",{"$f":"VLOOKUP(D48,'AOMS List Price'!A$2:B$243,2, FALSE)","v":27.88},{"$f":"BOM!F45","v":0},0]
["I/O Module","I/O",null,"RLD-134A",{"$f":"VLOOKUP(D49,'AOMS List Price'!A$2:B$243,2, FALSE)","v":2260.52},{"$f":"BOM!F46","v":0},0]
["I/O Module","I/O",null,"WD-1B",{"$f":"VLOOKUP(D50,'AOMS List Price'!A$2:B$243,2, FALSE)","v":231.6},{"$f":"BOM!F47","v":0},0]
["I/O Module","I/O",null,"WD-2-T-10",{"$f":"VLOOKUP(D51,'AOMS List Price'!A$2:B$243,2, FALSE)","v":543.79999999999995},{"$f":"BOM!F48","v":0},0]
["I/O Module","I/O",null,"WD-2-T-25",{"$f":"VLOOKUP(D52,'AOMS List Price'!A$2:B$243,2, FALSE)","v":839.6},{"$f":"BOM!F49","v":0},0]
["I/O Module","I/O",null,"CSDSC-C50100L0",{"$f":"VLOOKUP(D53,'AOMS List Price'!A$2:B$243,2, FALSE)","v":116.2},{"$f":"BOM!F50","v":0},0]
["I/O Module","I/O",null,"CSDSC-C50100L1",{"$f":"VLOOKUP(D54,'AOMS List Price'!A$2:B$243,2, FALSE)","v":185.77},{"$f":"BOM!F51","v":0},0]
["I/O Module","I/O",null,"CSDECM-C35200L0",{"$f":"VLOOKUP(D55,'AOMS List Price'!A$2:B$243,2, FALSE)","v":81.41},{"$f":"BOM!F52","v":0},0]
["I/O Module","I/O",null,"CSDECM-C35200L1",{"$f":"VLOOKUP(D56,'AOMS List Price'!A$2:B$243,2, FALSE)","v":150.99},{"$f":"BOM!F53","v":0},0]
["I/O Module","IOM Relay",null,"RIBU1C",{"$f":"VLOOKUP(D57,'AOMS List Price'!A$2:B$243,2, FALSE)","v":30.52},{"$f":"BOM!F54","v":0},0]
["I/O Module","IOM NS Sensor",null,"NS-BTN7003-0",{"$f":"VLOOKUP(D58,'AOMS List Price'!A$2:B$243,2, FALSE)","v":147.05000000000001},{"$f":"BOM!F55","v":0},0]
["I/O Module","IOM NS Sensor",null,"NS-BTN7003-2",{"$f":"VLOOKUP(D59,'AOMS List Price'!A$2:B$243,2, FALSE)","v":147.05000000000001},{"$f":"BOM!F56","v":0},0]
["I/O Module","IOM NS Sensor",null,"NS-BHN7003-0",{"$f":"VLOOKUP(D60,'AOMS List Price'!A$2:B$243,2, FALSE)","v":515.21},{"$f":"BOM!F57","v":0},0]
["I/O Module","IOM NS Sensor",null,"NS-BTN7001-0",{"$f":"VLOOKUP(D61,'AOMS List Price'!A$2:B$243,2, FALSE)","v":148.51},{"$f":"BOM!F58","v":0},0]
["I/O Module","IOM NS Sensor",null,"NS-BTN7001-2",{"$f":"VLOOKUP(D62,'AOMS List Price'!A$2:B$243,2, FALSE)","v":148.51},{"$f":"BOM!F59","v":0},0]
["I/O Module","IOM Wireless Receiver",null,"WRZ-7860-0",{"$f":"VLOOKUP(D63,'AOMS List Price'!A$2:B$243,2, FALSE)","v":237.68},{"$f":"BOM!F60","v":0},0]
["I/O Module","IOM Receiver Wire Extder",null,"ZFR-CBLEXT-0",{"$f":"VLOOKUP(D64,'AOMS List Price'!A$2:B$243,2, FALSE)","v":77.73},{"$f":"BOM!F61","v":0},0]
["I/O Module","IOM Wireless Sensor",null,"WRZ-STR0000-0",{"$f":"VLOOKUP(D65,'AOMS List Price'!A$2:B$243,2, FALSE)","v":923.02},{"$f":"BOM!F62","v":0},0]
["I/O Module","IOM Wireless Sensor",null,"WRZ-RMT10K-0",{"$f":"VLOOKUP(D66,'AOMS List Price'!A$2:B$243,2, FALSE)","v":778.9},{"$f":"BOM!F63","v":0},0]
["I/O Module","IOM Wireless Sensor",null,"WRZ-TTR0000-0",{"$f":"VLOOKUP(D67,'AOMS List Price'!A$2:B$243,2, FALSE)","v":267.77999999999997},{"$f":"BOM!F64","v":0},0]
["I/O Module","IOM Wireless Sensor",null,"WRZ-THN0000-0",{"$f":"VLOOKUP(D68,'AOMS List Price'!A$2:B$243,2, FALSE)","v":410.04},{"$f":"BOM!F65","v":0},0]
["I/O Module","IOM Energy Meter",null,{"$f":"'IOM Device - Energy Meter'!F33","v":"?"},{"$f":"VLOOKUP(D69,'AOMS List Price'!A$2:B$243,2, FALSE)","v":{"$error":"#N/A"}},{"$f":"BOM!F66","v":0},{"$f":"_xlfn.IFNA(E69*F69,0)","v":0}]
["I/O Module","IOM Energy Meter",null,{"$f":"'IOM Device - Energy Meter'!F34","v":"?"},{"$f":"VLOOKUP(D70,'AOMS List Price'!A$2:B$243,2, FALSE)","v":{"$error":"#N/A"}},{"$f":"BOM!F67","v":0},{"$f":"_xlfn.IFNA(E70*F70,0)","v":0}]
["I/O Module","IOM Energy Meter",null,{"$f":"'IOM Device - Energy Meter'!F35","v":"?"},{"$f":"VLOOKUP(D71,'AOMS List Price'!A$2:B$243,2, FALSE)","v":{"$error":"#N/A"}},{"$f":"BOM!F68","v":0},0]
["SZ - Smart Equipment","Zone Temperature",null,"NS-BTB7003-0",{"$f":"VLOOKUP(D72,'AOMS List Price'!A$2:B$243,2, FALSE)","v":189.94},{"$f":"BOM!F69","v":0},0]
["SZ - Smart Equipment","Zone Temperature",null,"NS-BTB7003-2",{"$f":"VLOOKUP(D73,'AOMS List Price'!A$2:B$243,2, FALSE)","v":189.94},{"$f":"BOM!F70","v":0},0]
["SZ - Smart Equipment","Zone Temperature",null,"NS-BTN7003-0",{"$f":"VLOOKUP(D74,'AOMS List Price'!A$2:B$243,2, FALSE)","v":147.05000000000001},{"$f":"BOM!F71","v":0},0]
["SZ - Smart Equipment","Zone Temperature",null,"NS-BTN7003-2",{"$f":"VLOOKUP(D75,'AOMS List Price'!A$2:B$243,2, FALSE)","v":147.05000000000001},{"$f":"BOM!F72","v":0},0]
["SZ - Smart Equipment","Zone Temperature",null,"NS-BTP7002-0",{"$f":"VLOOKUP(D76,'AOMS List Price'!A$2:B$243,2, FALSE)","v":156.21},{"$f":"BOM!F73","v":0},0]
["SZ - Smart Equipment","Zone Temperature",null,"NS-BTP7002-2",{"$f":"VLOOKUP(D77,'AOMS List Price'!A$2:B$243,2, FALSE)","v":156.21},{"$f":"BOM!F74","v":0},0]
["SZ - Smart Equipment","Zone Temperature",null,"NS-BHR7103-0",{"$f":"VLOOKUP(D78,'AOMS List Price'!A$2:B$243,2, FALSE)","v":693.51},{"$f":"BOM!F75","v":0},0]
["SZ - Smart Equipment","Zone Temperature",null,"NS-BHP7001-0",{"$f":"VLOOKUP(D79,'AOMS List Price'!A$2:B$243,2, FALSE)","v":539.24},{"$f":"BOM!F76","v":0},0]
["SZ - Smart Equipment","Zone Temperature",null,"NS-BTB7F03-0",{"$f":"VLOOKUP(D80,'AOMS List Price'!A$2:B$243,2, FALSE)","v":227.93},{"$f":"BOM!F77","v":0},0]
["SZ - Smart Equipment","Zone Temperature",null,"NS-BTK7002-0",{"$f":"VLOOKUP(D81,'AOMS List Price'!A$2:B$243,2, FALSE)","v":206},{"$f":"BOM!F78","v":0},{"$f":"E81*F81","v":0}]
["SZ - Smart Equipment","Zone Temperature",null,"NS-BTK7002-2",{"$f":"VLOOKUP(D82,'AOMS List Price'!A$2:B$243,2, FALSE)","v":206},{"$f":"BOM!F79","v":0},0]
["SZ - Smart Equipment","CO2 Sensor",null,"NS-BCN7004-0",{"$f":"VLOOKUP(D83,'AOMS List Price'!A$2:B$243,2, FALSE)","v":1156.49},{"$f":"BOM!F80","v":0},0]
["SZ - Smart Equipment","COMM CARD",null,"SE-COM1001-0",{"$f":"VLOOKUP(D84,'AOMS List Price'!A$2:B$243,2, FALSE)","v":177.79},{"$f":"BOM!F81","v":0},0]
["SZ - 3rd Party Units","Thermostat",null,"TEC3630-00-000",{"$f":"VLOOKUP(D85,'AOMS List Price'!A$2:B$243,2, FALSE)","v":685.26},{"$f":"BOM!F82","v":0},0]
["SZ - 3rd Party Units","Thermostat",null,"TEC3631-00-000",{"$f":"VLOOKUP(D86,'AOMS List Price'!A$2:B$243,2, FALSE)","v":761.22},{"$f":"BOM!F83","v":0},0]
["SZ - 3rd Party Units","Thermostat",null,"TEC3630-01-000",{"$f":"VLOOKUP(D87,'AOMS List Price'!A$2:B$243,2, FALSE)","v":685.26},{"$f":"BOM!F84","v":0},0]
["SZ - 3rd Party Units","Thermostat",null,"TEC3631-01-000",{"$f":"VLOOKUP(D88,'AOMS List Price'!A$2:B$243,2, FALSE)","v":761.22},{"$f":"BOM!F85","v":0},0]
["SZ - 3rd Party Units","Wireless Thermostat",null,"TEC3030-00-000",{"$f":"VLOOKUP(D89,'AOMS List Price'!A$2:B$243,2, FALSE)","v":592.44000000000005},{"$f":"BOM!F86","v":0},0]
["SZ - 3rd Party Units","Wireless Thermostat",null,"TEC3031-00-000",{"$f":"VLOOKUP(D90,'AOMS List Price'!A$2:B$243,2, FALSE)","v":761.22},{"$f":"BOM!F87","v":0},0]
["SZ - 3rd Party Units","Wireless Thermostat",null,"TEC3030-01-000",{"$f":"VLOOKUP(D91,'AOMS List Price'!A$2:B$243,2, FALSE)","v":592.44000000000005},{"$f":"BOM!F88","v":0},0]
["SZ - 3rd Party Units","Wireless Thermostat",null,"TEC3031-01-000",{"$f":"VLOOKUP(D92,'AOMS List Price'!A$2:B$243,2, FALSE)","v":761.22},{"$f":"BOM!F89","v":0},0]
["SZ - 3rd Party Units","Wireless Pro Coordinator",null,"LC-ZFR1825-0",{"$f":"VLOOKUP(D93,'AOMS List Price'!A$2:B$243,2, FALSE)","v":470.06},{"$f":"BOM!F90","v":0},0]
["SZ - 3rd Party Units","Wireless Repeater Kit",null,"LC-ZFR1821-0B",{"$f":"VLOOKUP(D94,'AOMS List Price'!A$2:B$243,2, FALSE)","v":205.35},{"$f":"BOM!F91","v":0},0]
["SZ - 3rd Party Units","Wireless Repeater Kit",null,"LC-ZFR1822-0B",{"$f":"VLOOKUP(D95,'AOMS List Price'!A$2:B$243,2, FALSE)","v":222.42},{"$f":"BOM!F92","v":0},0]
["SZ - 3rd Party Units","Supply Temp",null,"TE-6311M-1",{"$f":"VLOOKUP(D96,'AOMS List Price'!A$2:B$243,2, FALSE)","v":35.630000000000003},{"$f":"BOM!F93","v":0},0]
["SZ - 3rd Party Units","Outside Temp",null,"TE-6313P-1",{"$f":"VLOOKUP(D97,'AOMS List Price'!A$2:B$243,2, FALSE)","v":51.47},{"$f":"BOM!F94","v":0},0]
["SZ - 3rd Party Units","Remote Sensor",null,"TE-68NT-0N00S",{"$f":"VLOOKUP(D98,'AOMS List Price'!A$2:B$243,2, FALSE)","v":95.95},{"$f":"BOM!F95","v":0},0]
["SZ - 3rd Party Units","Wall plate",null,"TEC-WALLPLT",{"$f":"VLOOKUP(D99,'AOMS List Price'!A$2:B$243,2, FALSE)","v":10.71},{"$f":"BOM!F96","v":0},0]
["SZ - 3rd Party Units","Fan Status",null,"CSD-CF0A0-1",{"$f":"VLOOKUP(D100,'AOMS List Price'!A$2:B$243,2, FALSE)","v":84.07},{"$f":"BOM!F97","v":0},0]
["SZ - 3rd Party Units","Damper Actuator",null,"M9208-GGA-3",{"$f":"VLOOKUP(D101,'AOMS List Price'!A$2:B$243,2, FALSE)","v":493.34},{"$f":"BOM!F98","v":0},0]
["SZ - 3rd Party Units","Damper Actuator",null,"M9208-250",{"$f":"VLOOKUP(D102,'AOMS List Price'!A$2:B$243,2, FALSE)","v":131.12},{"$f":"BOM!F99","v":0},0]
["MZ- Zone Coordinator","Zone Coordinator",null,"LC-VZC100-0",{"$f":"VLOOKUP(D103,'AOMS List Price'!A$2:B$243,2, FALSE)","v":590.79999999999995},{"$f":"BOM!F100","v":0},0]
["MZ- Zone Coordinator","Zone Coordinator",null,"LC-VZCPNL-0",{"$f":"VLOOKUP(D104,'AOMS List Price'!A$2:B$243,2, FALSE)","v":1139.8900000000001},{"$f":"BOM!F101","v":0},0]
["MZ- Zone Coordinator","Zone Power",null,"Y65T42-0",{"$f":"VLOOKUP(D105,'AOMS List Price'!A$2:B$243,2, FALSE)","v":76.63},{"$f":"BOM!F102","v":0},0]
["MZ- Zone Coordinator","Zone Power",null,"PSH100A",{"$f":"VLOOKUP(D106,'AOMS List Price'!A$2:B$243,2, FALSE)","v":173.2},{"$f":"BOM!F103","v":0},0]
["MZ- Zone Coordinator","Zone Power",null,"PSH300A",{"$f":"VLOOKUP(D107,'AOMS List Price'!A$2:B$243,2, FALSE)","v":592.04},{"$f":"BOM!F104","v":0},0]
["MZ- Zone Coordinator","Zone Power",null,"PSH500A",{"$f":"VLOOKUP(D108,'AOMS List Price'!A$2:B$243,2, FALSE)","v":799.4},{"$f":"BOM!F105","v":0},0]
["MZ - Smart Equipment","COMM CARD",null,"SE-COM1001-0",{"$f":"VLOOKUP(D109,'AOMS List Price'!A$2:B$243,2, FALSE)","v":177.79},{"$f":"BOM!F106","v":0},0]
["MZ- 3rd Party Units","3rd Party Controller",null,"LC-VEC100-0",{"$f":"VLOOKUP(D110,'AOMS List Price'!A$2:B$243,2, FALSE)","v":698.56},{"$f":"BOM!F107","v":0},0]
["MZ- 3rd Party Units","Duct Sensors",null,"TE-6311M-1",{"$f":"VLOOKUP(D111,'AOMS List Price'!A$2:B$243,2, FALSE)","v":35.630000000000003},{"$f":"BOM!F108","v":0},0]
["MZ- 3rd Party Units","Static Pressure Sensor",null,"DPT2640-005D",{"$f":"VLOOKUP(D112,'AOMS List Price'!A$2:B$243,2, FALSE)","v":333.24},{"$f":"BOM!F109","v":0},0]
["MZ- 3rd Party Units","Static Pressure Probe",null,"FTG18A-600R",{"$f":"VLOOKUP(D113,'AOMS List Price'!A$2:B$243,2, FALSE)","v":37.380000000000003},{"$f":"BOM!F110","v":0},0]
["MZ- 3rd Party Units","Outside Temp",null,"TE-6313P-1",{"$f":"VLOOKUP(D114,'AOMS List Price'!A$2:B$243,2, FALSE)","v":51.47},{"$f":"BOM!F111","v":0},0]
["MZ- 3rd Party Units","Filter Status",null,"P32AC-2C",{"$f":"VLOOKUP(D115,'AOMS List Price'!A$2:B$243,2, FALSE)","v":159.03},{"$f":"BOM!F112","v":0},0]
["MZ- 3rd Party Units","Filter Status",null,"FTG18A-600R",{"$f":"VLOOKUP(D116,'AOMS List Price'!A$2:B$243,2, FALSE)","v":37.380000000000003},{"$f":"BOM!F113","v":0},0]
["MZ- 3rd Party Units","Fan Status",null,"CSD-CF0A0-1",{"$f":"VLOOKUP(D117,'AOMS List Price'!A$2:B$243,2, FALSE)","v":84.07},{"$f":"BOM!F114","v":0},0]
["MZ- 3rd Party Units","Return CO2 Sensor",null,"CD-P1000-00-00",{"$f":"VLOOKUP(D118,'AOMS List Price'!A$2:B$243,2, FALSE)","v":1158.92},{"$f":"BOM!F115","v":0},0]
["MZ- 3rd Party Units","Zone Humidity",null,"NS-BHN7003-0",{"$f":"VLOOKUP(D119,'AOMS List Price'!A$2:B$243,2, FALSE)","v":515.21},{"$f":"BOM!F116","v":0},0]
["MZ- 3rd Party Units","Damper Actuator",null,"M9208-GGA-3",{"$f":"VLOOKUP(D120,'AOMS List Price'!A$2:B$243,2, FALSE)","v":493.34},{"$f":"BOM!F117","v":0},0]
["MZ- 3rd Party Units","Damper Actuator",null,"M9208-250",{"$f":"VLOOKUP(D121,'AOMS List Price'!A$2:B$243,2, FALSE)","v":131.12},{"$f":"BOM!F118","v":0},0]
["MZ- VAV Zones","Controller",null,"LC-ZEC410-1",{"$f":"VLOOKUP(D122,'AOMS List Price'!A$2:B$243,2, FALSE)","v":583.73},{"$f":"BOM!F119","v":0},0]
["MZ- VAV Zones","Controller",null,"LC-ZEC410-2",{"$f":"VLOOKUP(D123,'AOMS List Price'!A$2:B$243,2, FALSE)","v":583.73},{"$f":"BOM!F120","v":0},0]
["MZ- VAV Zones","Controller",null,"LC-ZEC410-3",{"$f":"VLOOKUP(D124,'AOMS List Price'!A$2:B$243,2, FALSE)","v":583.73},{"$f":"BOM!F121","v":0},0]
["MZ- VAV Zones","Zone Temperature",null,"NS-BTB7003-0",{"$f":"VLOOKUP(D125,'AOMS List Price'!A$2:B$243,2, FALSE)","v":189.94},{"$f":"BOM!F122","v":0},0]
["MZ- VAV Zones","Zone Temperature",null,"NS-BTB7003-2",{"$f":"VLOOKUP(D126,'AOMS List Price'!A$2:B$243,2, FALSE)","v":189.94},{"$f":"BOM!F123","v":0},0]
["MZ- VAV Zones","Zone Temperature",null,"NS-BTN7003-0",{"$f":"VLOOKUP(D127,'AOMS List Price'!A$2:B$243,2, FALSE)","v":147.05000000000001},{"$f":"BOM!F124","v":0},0]
["MZ- VAV Zones","Zone Temperature",null,"NS-BTN7003-2",{"$f":"VLOOKUP(D128,'AOMS List Price'!A$2:B$243,2, FALSE)","v":147.05000000000001},{"$f":"BOM!F125","v":0},0]
["MZ- VAV Zones","Zone Temperature",null,"NS-BTP7002-0",{"$f":"VLOOKUP(D129,'AOMS List Price'!A$2:B$243,2, FALSE)","v":156.21},{"$f":"BOM!F126","v":0},0]
["MZ- VAV Zones","Zone Temperature",null,"NS-BTP7002-2",{"$f":"VLOOKUP(D130,'AOMS List Price'!A$2:B$243,2, FALSE)","v":156.21},{"$f":"BOM!F127","v":0},0]
["MZ- VAV Zones","Zone Temperature",null,"NS-BTK7002-0",{"$f":"VLOOKUP(D131,'AOMS List Price'!A$2:B$243,2, FALSE)","v":206},{"$f":"BOM!F128","v":0},0]
["MZ- VAV Zones","Zone Temperature",null,"NS-BTK7002-2",{"$f":"VLOOKUP(D132,'AOMS List Price'!A$2:B$243,2, FALSE)","v":206},{"$f":"BOM!F129","v":0},0]
["MZ- VAV Zones","Discharge Temp",null,"TE-631GV-2",{"$f":"VLOOKUP(D133,'AOMS List Price'!A$2:B$243,2, FALSE)","v":35.61},{"$f":"BOM!F130","v":0},0]
["MZ- VAV Zones","CO2 Sensor",null,"NS-BCN7004-0",{"$f":"VLOOKUP(D134,'AOMS List Price'!A$2:B$243,2, FALSE)","v":1156.49},{"$f":"BOM!F131","v":0},0]
["MZ- VAV Zones","Occupancy Lighting",null,"OLS-2100-1",{"$f":"VLOOKUP(D135,'AOMS List Price'!A$2:B$243,2, FALSE)","v":367.69},{"$f":"BOM!F132","v":0},0]
["MZ- VAV Zones","Occupancy Lighting",null,"RIBU1C",{"$f":"VLOOKUP(D136,'AOMS List Price'!A$2:B$243,2, FALSE)","v":30.52},{"$f":"BOM!F133","v":0},0]
["MZ- VAV Zones","Balancing",null,"NS-ATV7003-0",{"$f":"VLOOKUP(D137,'AOMS List Price'!A$2:B$243,2, FALSE)","v":245.07},{"$f":"BOM!F134","v":0},0]
["MZ - COBP Zones","Zone Temperature",null,"NS-BTB7003-0",{"$f":"VLOOKUP(D138,'AOMS List Price'!A$2:B$243,2, FALSE)","v":189.94},{"$f":"BOM!F135","v":0},0]
["MZ - COBP Zones","Zone Temperature",null,"NS-BTB7003-2",{"$f":"VLOOKUP(D139,'AOMS List Price'!A$2:B$243,2, FALSE)","v":189.94},{"$f":"BOM!F136","v":0},0]
["MZ - COBP Zones","Zone Temperature",null,"NS-BTN7003-0",{"$f":"VLOOKUP(D140,'AOMS List Price'!A$2:B$243,2, FALSE)","v":147.05000000000001},{"$f":"BOM!F137","v":0},0]
["MZ - COBP Zones","Zone Temperature",null,"NS-BTN7003-2",{"$f":"VLOOKUP(D141,'AOMS List Price'!A$2:B$243,2, FALSE)","v":147.05000000000001},{"$f":"BOM!F138","v":0},0]
["MZ - COBP Zones","Zone Temperature",null,"NS-BTP7002-0",{"$f":"VLOOKUP(D142,'AOMS List Price'!A$2:B$243,2, FALSE)","v":156.21},{"$f":"BOM!F139","v":0},0]
["MZ - COBP Zones","Zone Temperature",null,"NS-BTP7002-2",{"$f":"VLOOKUP(D143,'AOMS List Price'!A$2:B$243,2, FALSE)","v":156.21},{"$f":"BOM!F140","v":0},0]
["MZ - COBP Zones","Zone Temperature",null,"NS-BTK7002-0",{"$f":"VLOOKUP(D144,'AOMS List Price'!A$2:B$243,2, FALSE)","v":206},{"$f":"BOM!F141","v":0},0]
["MZ - COBP Zones","Zone Temperature",null,"NS-BTK7002-2",{"$f":"VLOOKUP(D145,'AOMS List Price'!A$2:B$243,2, FALSE)","v":206},{"$f":"BOM!F142","v":0},{"$f":"E145*F145","v":0}]
["MZ - COBP Zones","Zone Temperature",null,"TE-68NT-0N00S",{"$f":"VLOOKUP(D146,'AOMS List Price'!A$2:B$243,2, FALSE)","v":95.95},{"$f":"BOM!F143","v":0},0]
["MZ - COBP Zones","Zone Temperature",null,"TE-68NT-1N00S",{"$f":"VLOOKUP(D147,'AOMS List Price'!A$2:B$243,2, FALSE)","v":107.01},{"$f":"BOM!F144","v":0},0]
["MZ - COBP Zones","CO2 Sensor",null,"NS-BCN7004-0",{"$f":"VLOOKUP(D148,'AOMS List Price'!A$2:B$243,2, FALSE)","v":1156.49},{"$f":"BOM!F145","v":0},0]
["MZ - COBP Zones","Controller",null,"LC-ZEC310-0",{"$f":"VLOOKUP(D149,'AOMS List Price'!A$2:B$243,2, FALSE)","v":564.74},{"$f":"BOM!F146","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG04B",{"$f":"VLOOKUP(D150,'AOMS List Price'!A$2:B$243,2, FALSE)","v":189.51480000000001},{"$f":"BOM!F147","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG06B",{"$f":"VLOOKUP(D151,'AOMS List Price'!A$2:B$243,2, FALSE)","v":191.8458},{"$f":"BOM!F148","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG07B",{"$f":"VLOOKUP(D152,'AOMS List Price'!A$2:B$243,2, FALSE)","v":196.55179999999999},{"$f":"BOM!F149","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG08B",{"$f":"VLOOKUP(D153,'AOMS List Price'!A$2:B$243,2, FALSE)","v":201.2139},{"$f":"BOM!F150","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG09B",{"$f":"VLOOKUP(D154,'AOMS List Price'!A$2:B$243,2, FALSE)","v":205.92},{"$f":"BOM!F151","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG10B",{"$f":"VLOOKUP(D155,'AOMS List Price'!A$2:B$243,2, FALSE)","v":208.20590000000001},{"$f":"BOM!F152","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG11B",{"$f":"VLOOKUP(D156,'AOMS List Price'!A$2:B$243,2, FALSE)","v":219.95},{"$f":"BOM!F153","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG12B",{"$f":"VLOOKUP(D157,'AOMS List Price'!A$2:B$243,2, FALSE)","v":226.9427},{"$f":"BOM!F154","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG13B",{"$f":"VLOOKUP(D158,'AOMS List Price'!A$2:B$243,2, FALSE)","v":238.64179999999999},{"$f":"BOM!F155","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG14B",{"$f":"VLOOKUP(D159,'AOMS List Price'!A$2:B$243,2, FALSE)","v":255.047},{"$f":"BOM!F156","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG15B",{"$f":"VLOOKUP(D160,'AOMS List Price'!A$2:B$243,2, FALSE)","v":259.7088},{"$f":"BOM!F157","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG16B",{"$f":"VLOOKUP(D161,'AOMS List Price'!A$2:B$243,2, FALSE)","v":269.077},{"$f":"BOM!F158","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG17B",{"$f":"VLOOKUP(D162,'AOMS List Price'!A$2:B$243,2, FALSE)","v":320.53480000000002},{"$f":"BOM!F159","v":0},0]
["MZ - COBP Zones","Zone Damper",null,"RCG18B",{"$f":"VLOOKUP(D163,'AOMS List Price'!A$2:B$243,2, FALSE)","v":341.60180000000003},{"$f":"BOM!F160","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV06Z",{"$f":"VLOOKUP(D164,'AOMS List Price'!A$2:B$243,2, FALSE)","v":774.14},{"$f":"BOM!F161","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV07Z",{"$f":"VLOOKUP(D165,'AOMS List Price'!A$2:B$243,2, FALSE)","v":786.97},{"$f":"BOM!F162","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV08Z",{"$f":"VLOOKUP(D166,'AOMS List Price'!A$2:B$243,2, FALSE)","v":786.97},{"$f":"BOM!F163","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV09Z",{"$f":"VLOOKUP(D167,'AOMS List Price'!A$2:B$243,2, FALSE)","v":796.62},{"$f":"BOM!F164","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV10Z",{"$f":"VLOOKUP(D168,'AOMS List Price'!A$2:B$243,2, FALSE)","v":796.62},{"$f":"BOM!F165","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV11Z",{"$f":"VLOOKUP(D169,'AOMS List Price'!A$2:B$243,2, FALSE)","v":822.32},{"$f":"BOM!F166","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV12Z",{"$f":"VLOOKUP(D170,'AOMS List Price'!A$2:B$243,2, FALSE)","v":822.32},{"$f":"BOM!F167","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV13Z",{"$f":"VLOOKUP(D171,'AOMS List Price'!A$2:B$243,2, FALSE)","v":860.86},{"$f":"BOM!F168","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV14Z",{"$f":"VLOOKUP(D172,'AOMS List Price'!A$2:B$243,2, FALSE)","v":860.86},{"$f":"BOM!F169","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV15Z",{"$f":"VLOOKUP(D173,'AOMS List Price'!A$2:B$243,2, FALSE)","v":880.1},{"$f":"BOM!F170","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV16Z",{"$f":"VLOOKUP(D174,'AOMS List Price'!A$2:B$243,2, FALSE)","v":880.1},{"$f":"BOM!F171","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV17Z",{"$f":"VLOOKUP(D175,'AOMS List Price'!A$2:B$243,2, FALSE)","v":979.7},{"$f":"BOM!F172","v":0},0]
["MZ - COBP Zones","Zone Damper/Controller",null,"RZV18Z",{"$f":"VLOOKUP(D176,'AOMS List Price'!A$2:B$243,2, FALSE)","v":979.7},{"$f":"BOM!F173","v":0},0]
["MZ - COBP Zones","Occupancy Lighting",null,"OLS-2100-1",{"$f":"VLOOKUP(D177,'AOMS List Price'!A$2:B$243,2, FALSE)","v":367.69},{"$f":"BOM!F174","v":0},0]
["MZ - COBP Zones","Occupancy Lighting",null,"RIBU1C",{"$f":"VLOOKUP(D178,'AOMS List Price'!A$2:B$243,2, FALSE)","v":30.52},{"$f":"BOM!F175","v":0},0]
["MZ - COBP Zones","Second Zone Damper",null,"M9310-HGA-2",{"$f":"VLOOKUP(D179,'AOMS List Price'!A$2:B$243,2, FALSE)","v":366.24},{"$f":"BOM!F176","v":0},0]
["MZ- Bypass Damper","Controller",null,"LC-BYP200-0",{"$f":"VLOOKUP(D180,'AOMS List Price'!A$2:B$243,2, FALSE)","v":604.27},{"$f":"BOM!F177","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG06B",{"$f":"VLOOKUP(D181,'AOMS List Price'!A$2:B$243,2, FALSE)","v":191.8458},{"$f":"BOM!F178","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG07B",{"$f":"VLOOKUP(D182,'AOMS List Price'!A$2:B$243,2, FALSE)","v":196.55179999999999},{"$f":"BOM!F179","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG08B",{"$f":"VLOOKUP(D183,'AOMS List Price'!A$2:B$243,2, FALSE)","v":201.2139},{"$f":"BOM!F180","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG09B",{"$f":"VLOOKUP(D184,'AOMS List Price'!A$2:B$243,2, FALSE)","v":205.92},{"$f":"BOM!F181","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG10B",{"$f":"VLOOKUP(D185,'AOMS List Price'!A$2:B$243,2, FALSE)","v":208.20590000000001},{"$f":"BOM!F182","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG11B",{"$f":"VLOOKUP(D186,'AOMS List Price'!A$2:B$243,2, FALSE)","v":219.95},{"$f":"BOM!F183","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG12B",{"$f":"VLOOKUP(D187,'AOMS List Price'!A$2:B$243,2, FALSE)","v":226.9427},{"$f":"BOM!F184","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG13B",{"$f":"VLOOKUP(D188,'AOMS List Price'!A$2:B$243,2, FALSE)","v":238.64179999999999},{"$f":"BOM!F185","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG14B",{"$f":"VLOOKUP(D189,'AOMS List Price'!A$2:B$243,2, FALSE)","v":255.047},{"$f":"BOM!F186","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG15B",{"$f":"VLOOKUP(D190,'AOMS List Price'!A$2:B$243,2, FALSE)","v":259.7088},{"$f":"BOM!F187","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG16B",{"$f":"VLOOKUP(D191,'AOMS List Price'!A$2:B$243,2, FALSE)","v":269.077},{"$f":"BOM!F188","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG17B",{"$f":"VLOOKUP(D192,'AOMS List Price'!A$2:B$243,2, FALSE)","v":320.53480000000002},{"$f":"BOM!F189","v":0},0]
["MZ- Bypass Damper","Bypass Damper",null,"RCG18B",{"$f":"VLOOKUP(D193,'AOMS List Price'!A$2:B$243,2, FALSE)","v":341.60180000000003},{"$f":"BOM!F190","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV06Y",{"$f":"VLOOKUP(D194,'AOMS List Price'!A$2:B$243,2, FALSE)","v":749.24},{"$f":"BOM!F191","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV07Y",{"$f":"VLOOKUP(D195,'AOMS List Price'!A$2:B$243,2, FALSE)","v":762.07},{"$f":"BOM!F192","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV08Y",{"$f":"VLOOKUP(D196,'AOMS List Price'!A$2:B$243,2, FALSE)","v":762.07},{"$f":"BOM!F193","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV09Y",{"$f":"VLOOKUP(D197,'AOMS List Price'!A$2:B$243,2, FALSE)","v":771.72},{"$f":"BOM!F194","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV10Y",{"$f":"VLOOKUP(D198,'AOMS List Price'!A$2:B$243,2, FALSE)","v":771.72},{"$f":"BOM!F195","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV11Y",{"$f":"VLOOKUP(D199,'AOMS List Price'!A$2:B$243,2, FALSE)","v":797.42},{"$f":"BOM!F196","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV12Y",{"$f":"VLOOKUP(D200,'AOMS List Price'!A$2:B$243,2, FALSE)","v":797.42},{"$f":"BOM!F197","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV13Y",{"$f":"VLOOKUP(D201,'AOMS List Price'!A$2:B$243,2, FALSE)","v":835.96},{"$f":"BOM!F198","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV14Y",{"$f":"VLOOKUP(D202,'AOMS List Price'!A$2:B$243,2, FALSE)","v":835.96},{"$f":"BOM!F199","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV15Y",{"$f":"VLOOKUP(D203,'AOMS List Price'!A$2:B$243,2, FALSE)","v":855.25},{"$f":"BOM!F200","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV16Y",{"$f":"VLOOKUP(D204,'AOMS List Price'!A$2:B$243,2, FALSE)","v":855.25},{"$f":"BOM!F201","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV17Y",{"$f":"VLOOKUP(D205,'AOMS List Price'!A$2:B$243,2, FALSE)","v":954.79},{"$f":"BOM!F202","v":0},0]
["MZ- Bypass Damper","Bypass Damper/Controller",null,"RZV18Y",{"$f":"VLOOKUP(D206,'AOMS List Price'!A$2:B$243,2, FALSE)","v":954.79},{"$f":"BOM!F203","v":0},0]
["MZ- Bypass Damper","Static Pressure Sensor",null,"DPT2640-005D",{"$f":"VLOOKUP(D207,'AOMS List Price'!A$2:B$243,2, FALSE)","v":333.24},{"$f":"BOM!F204","v":0},0]
["MZ- Bypass Damper","Static Pressure Probe",null,"FTG18A-600R",{"$f":"VLOOKUP(D208,'AOMS List Price'!A$2:B$243,2, FALSE)","v":37.380000000000003},{"$f":"BOM!F205","v":0},0]
["MZ- Bypass Damper","Bypass Power",null,"Y65T42-0",{"$f":"VLOOKUP(D209,'AOMS List Price'!A$2:B$243,2, FALSE)","v":76.63},{"$f":"BOM!F206","v":0},{"$f":"E209*F209","v":0}]
["MZ- Bypass Damper","Second Bypass Damper",null,"M9310-HGA-2",{"$f":"VLOOKUP(D210,'AOMS List Price'!A$2:B$243,2, FALSE)","v":366.24},{"$f":"BOM!F207","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3610-00-000",{"$f":"VLOOKUP(D211,'AOMS List Price'!A$2:B$243,2, FALSE)","v":661.12},{"$f":"BOM!F208","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3611-00-000",{"$f":"VLOOKUP(D212,'AOMS List Price'!A$2:B$243,2, FALSE)","v":737.08},{"$f":"BOM!F209","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3612-00-000",{"$f":"VLOOKUP(D213,'AOMS List Price'!A$2:B$243,2, FALSE)","v":744.15},{"$f":"BOM!F210","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3613-00-000",{"$f":"VLOOKUP(D214,'AOMS List Price'!A$2:B$243,2, FALSE)","v":823.72},{"$f":"BOM!F211","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3620-00-000",{"$f":"VLOOKUP(D215,'AOMS List Price'!A$2:B$243,2, FALSE)","v":737.38},{"$f":"BOM!F212","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3621-00-000",{"$f":"VLOOKUP(D216,'AOMS List Price'!A$2:B$243,2, FALSE)","v":813.34},{"$f":"BOM!F213","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3622-00-000",{"$f":"VLOOKUP(D217,'AOMS List Price'!A$2:B$243,2, FALSE)","v":820.41},{"$f":"BOM!F214","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3623-00-000",{"$f":"VLOOKUP(D218,'AOMS List Price'!A$2:B$243,2, FALSE)","v":899.98},{"$f":"BOM!F215","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3610-01-000",{"$f":"VLOOKUP(D219,'AOMS List Price'!A$2:B$243,2, FALSE)","v":661.12},{"$f":"BOM!F216","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3611-01-000",{"$f":"VLOOKUP(D220,'AOMS List Price'!A$2:B$243,2, FALSE)","v":737.08},{"$f":"BOM!F217","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3612-01-000",{"$f":"VLOOKUP(D221,'AOMS List Price'!A$2:B$243,2, FALSE)","v":744.15},{"$f":"BOM!F218","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3613-01-000",{"$f":"VLOOKUP(D222,'AOMS List Price'!A$2:B$243,2, FALSE)","v":823.72},{"$f":"BOM!F219","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3620-01-000",{"$f":"VLOOKUP(D223,'AOMS List Price'!A$2:B$243,2, FALSE)","v":737.38},{"$f":"BOM!F220","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3621-01-000",{"$f":"VLOOKUP(D224,'AOMS List Price'!A$2:B$243,2, FALSE)","v":813.34},{"$f":"BOM!F221","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3622-01-000",{"$f":"VLOOKUP(D225,'AOMS List Price'!A$2:B$243,2, FALSE)","v":820.41},{"$f":"BOM!F222","v":0},0]
["Fan Coil Units","Thermostat",null,"TEC3623-01-000",{"$f":"VLOOKUP(D226,'AOMS List Price'!A$2:B$243,2, FALSE)","v":899.98},{"$f":"BOM!F223","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3010-00-000",{"$f":"VLOOKUP(D227,'AOMS List Price'!A$2:B$243,2, FALSE)","v":661.12},{"$f":"BOM!F224","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3011-00-000",{"$f":"VLOOKUP(D228,'AOMS List Price'!A$2:B$243,2, FALSE)","v":737.08},{"$f":"BOM!F225","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3012-00-000",{"$f":"VLOOKUP(D229,'AOMS List Price'!A$2:B$243,2, FALSE)","v":842.07},{"$f":"BOM!F226","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3013-00-000",{"$f":"VLOOKUP(D230,'AOMS List Price'!A$2:B$243,2, FALSE)","v":823.72},{"$f":"BOM!F227","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3020-00-000",{"$f":"VLOOKUP(D231,'AOMS List Price'!A$2:B$243,2, FALSE)","v":716.98},{"$f":"BOM!F228","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3021-00-000",{"$f":"VLOOKUP(D232,'AOMS List Price'!A$2:B$243,2, FALSE)","v":813.34},{"$f":"BOM!F229","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3022-00-000",{"$f":"VLOOKUP(D233,'AOMS List Price'!A$2:B$243,2, FALSE)","v":820.41},{"$f":"BOM!F230","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3023-00-000",{"$f":"VLOOKUP(D234,'AOMS List Price'!A$2:B$243,2, FALSE)","v":899.98},{"$f":"BOM!F231","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3010-01-000",{"$f":"VLOOKUP(D235,'AOMS List Price'!A$2:B$243,2, FALSE)","v":661.12},{"$f":"BOM!F232","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3011-01-000",{"$f":"VLOOKUP(D236,'AOMS List Price'!A$2:B$243,2, FALSE)","v":737.08},{"$f":"BOM!F233","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3012-01-000",{"$f":"VLOOKUP(D237,'AOMS List Price'!A$2:B$243,2, FALSE)","v":842.07},{"$f":"BOM!F234","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3013-01-000",{"$f":"VLOOKUP(D238,'AOMS List Price'!A$2:B$243,2, FALSE)","v":823.72},{"$f":"BOM!F235","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3020-01-000",{"$f":"VLOOKUP(D239,'AOMS List Price'!A$2:B$243,2, FALSE)","v":716.98},{"$f":"BOM!F236","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3021-01-000",{"$f":"VLOOKUP(D240,'AOMS List Price'!A$2:B$243,2, FALSE)","v":813.34},{"$f":"BOM!F237","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3022-01-000",{"$f":"VLOOKUP(D241,'AOMS List Price'!A$2:B$243,2, FALSE)","v":820.41},{"$f":"BOM!F238","v":0},0]
["Fan Coil Units","Wireless Thermostat",null,"TEC3023-01-000",{"$f":"VLOOKUP(D242,'AOMS List Price'!A$2:B$243,2, FALSE)","v":899.98},{"$f":"BOM!F239","v":0},0]
["Fan Coil Units","Supply Temp",null,"TE-6311M-1",{"$f":"VLOOKUP(D243,'AOMS List Price'!A$2:B$243,2, FALSE)","v":35.630000000000003},{"$f":"BOM!F240","v":0},0]
["Fan Coil Units","Remote Sensor",null,"TE-68NT-0N00S",{"$f":"VLOOKUP(D244,'AOMS List Price'!A$2:B$243,2, FALSE)","v":95.95},{"$f":"BOM!F241","v":0},0]
["Fan Coil Units","Fan Status",null,"CSD-CF0A0-1",{"$f":"VLOOKUP(D245,'AOMS List Price'!A$2:B$243,2, FALSE)","v":84.07},{"$f":"BOM!F242","v":0},0]
["Fan Coil Units","Wall plate",null,"TEC-WALLPLT",{"$f":"VLOOKUP(D246,'AOMS List Price'!A$2:B$243,2, FALSE)","v":10.71},{"$f":"BOM!F243","v":0},0]
["Fan Coil Units","Wireless Pro Coordinator",null,"LC-ZFR1825-0",{"$f":"VLOOKUP(D247,'AOMS List Price'!A$2:B$243,2, FALSE)","v":470.06},{"$f":"BOM!F244","v":0},0]
["Fan Coil Units","Wireless Repeater Kit",null,"LC-ZFR1821-0B",{"$f":"VLOOKUP(D248,'AOMS List Price'!A$2:B$243,2, FALSE)","v":205.35},{"$f":"BOM!F245","v":0},0]
["Fan Coil Units","Wireless Repeater Kit",null,"LC-ZFR1822-0B",{"$f":"VLOOKUP(D249,'AOMS List Price'!A$2:B$243,2, FALSE)","v":222.42},{"$f":"BOM!F246","v":0},0]
["Advanced Application","Application Controller",null,"LC-VAC1000-0",{"$f":"VLOOKUP(D250,'AOMS List Price'!A$2:B$243,2, FALSE)","v":665.3},{"$f":"BOM!F247","v":0},0]
["Advanced Application","Application Controller",null,"LC-VAC3000-0",{"$f":"VLOOKUP(D251,'AOMS List Price'!A$2:B$243,2, FALSE)","v":"N/A"},{"$f":"BOM!F248","v":0}]
["Advanced Application","Application I/O",null,"TE-6311M-1",{"$f":"VLOOKUP(D252,'AOMS List Price'!A$2:B$243,2, FALSE)","v":35.630000000000003},{"$f":"BOM!F249","v":0},0]
["Advanced Application","Application I/O",null,"TE-6315M-1",{"$f":"VLOOKUP(D253,'AOMS List Price'!A$2:B$243,2, FALSE)","v":158.72},{"$f":"BOM!F250","v":0},0]
["Advanced Application","Application I/O",null,"TE-6313P-1",{"$f":"VLOOKUP(D254,'AOMS List Price'!A$2:B$243,2, FALSE)","v":51.47},{"$f":"BOM!F251","v":0},0]
["Advanced Application","Application I/O",null,"CSDECM-C35200L0",{"$f":"VLOOKUP(D255,'AOMS List Price'!A$2:B$243,2, FALSE)","v":81.41},{"$f":"BOM!F252","v":0},0]
["Advanced Application","Application I/O",null,"A70HA-1C",{"$f":"VLOOKUP(D256,'AOMS List Price'!A$2:B$243,2, FALSE)","v":376.93},{"$f":"BOM!F253","v":0},0]
["Advanced Application","Application I/O",null,"TE-6001-8",{"$f":"VLOOKUP(D257,'AOMS List Price'!A$2:B$243,2, FALSE)","v":12.62},{"$f":"BOM!F254","v":0},0]
["Advanced Application","Application I/O",null,"OLS-2100-1",{"$f":"VLOOKUP(D258,'AOMS List Price'!A$2:B$243,2, FALSE)","v":367.69},{"$f":"BOM!F255","v":0},0]
["Advanced Application","Application Relay",null,"RIBU1C",{"$f":"VLOOKUP(D259,'AOMS List Price'!A$2:B$243,2, FALSE)","v":30.52},{"$f":"BOM!F256","v":0},0]
["Advanced Application","Application Actuator",null,"M9208-GGA-3",{"$f":"VLOOKUP(D260,'AOMS List Price'!A$2:B$243,2, FALSE)","v":493.34},{"$f":"BOM!F257","v":0},0]
["Advanced Application","Application Actuator",null,"M9208-250",{"$f":"VLOOKUP(D261,'AOMS List Price'!A$2:B$243,2, FALSE)","v":131.12},{"$f":"BOM!F258","v":0},0]
["Advanced Application","Application I/O",null,"NS-BTB7003-0",{"$f":"VLOOKUP(D262,'AOMS List Price'!A$2:B$243,2, FALSE)","v":189.94},{"$f":"BOM!F259","v":0},0]
["Advanced Application","Application I/O",null,"NS-BTB7003-2",{"$f":"VLOOKUP(D263,'AOMS List Price'!A$2:B$243,2, FALSE)","v":189.94},{"$f":"BOM!F260","v":0},0]
["Advanced Application","Application I/O",null,"NS-BTN7003-0",{"$f":"VLOOKUP(D264,'AOMS List Price'!A$2:B$243,2, FALSE)","v":147.05000000000001},{"$f":"BOM!F261","v":0},0]
["Advanced Application","Application I/O",null,"NS-BTN7003-2",{"$f":"VLOOKUP(D265,'AOMS List Price'!A$2:B$243,2, FALSE)","v":147.05000000000001},{"$f":"BOM!F262","v":0},0]
["Advanced Application","Application I/O",null,"NS-BTP7002-0",{"$f":"VLOOKUP(D266,'AOMS List Price'!A$2:B$243,2, FALSE)","v":156.21},{"$f":"BOM!F263","v":0},0]
["Advanced Application","Application I/O",null,"NS-BTP7002-2",{"$f":"VLOOKUP(D267,'AOMS List Price'!A$2:B$243,2, FALSE)","v":156.21},{"$f":"BOM!F264","v":0},0]
["Advanced Application","Application I/O",null,"NS-BTJ7002-0",{"$f":"VLOOKUP(D268,'AOMS List Price'!A$2:B$243,2, FALSE)","v":190.55},{"$f":"BOM!F265","v":0},0]
["Advanced Application","Application I/O",null,"NS-BTJ7002-2",{"$f":"VLOOKUP(D269,'AOMS List Price'!A$2:B$243,2, FALSE)","v":190.55},{"$f":"BOM!F266","v":0},0]
["Advanced Application","Application I/O",null,"NS-BHR7103-0",{"$f":"VLOOKUP(D270,'AOMS List Price'!A$2:B$243,2, FALSE)","v":693.51},{"$f":"BOM!F267","v":0},0]
["Advanced Application","Application I/O",null,"NS-BHN7003-0",{"$f":"VLOOKUP(D271,'AOMS List Price'!A$2:B$243,2, FALSE)","v":515.21},{"$f":"BOM!F268","v":0},0]
["Advanced Application","Application I/O",null,"NS-BHP7003-0",{"$f":"VLOOKUP(D272,'AOMS List Price'!A$2:B$243,2, FALSE)","v":710.15},{"$f":"BOM!F269","v":0},0]
["Advanced Application","Application I/O",null,"NS-BHM7103-2",{"$f":"VLOOKUP(D273,'AOMS List Price'!A$2:B$243,2, FALSE)","v":693.19},{"$f":"BOM!F270","v":0},{"$f":"E273*F273","v":0}]
["Advanced Application","Application I/O",null,"NS-BTB7F03-0",{"$f":"VLOOKUP(D274,'AOMS List Price'!A$2:B$243,2, FALSE)","v":227.93},{"$f":"BOM!F271","v":0},0]
["Advanced Application","Application I/O",null,"NS-BCN7004-0",{"$f":"VLOOKUP(D275,'AOMS List Price'!A$2:B$243,2, FALSE)","v":1156.49},{"$f":"BOM!F272","v":0},0]
["Advanced Application","Application I/O",null,"HE-67N3-0N00P",{"$f":"VLOOKUP(D276,'AOMS List Price'!A$2:B$243,2, FALSE)","v":469.4},{"$f":"BOM!F273","v":0},0]
["Advanced Application","Application I/O",null,"CD-P1000-00-00",{"$f":"VLOOKUP(D277,'AOMS List Price'!A$2:B$243,2, FALSE)","v":1158.92},{"$f":"BOM!F274","v":0},0]
["Advanced Application","Application I/O",null,"P32AC-2C",{"$f":"VLOOKUP(D278,'AOMS List Price'!A$2:B$243,2, FALSE)","v":159.03},{"$f":"BOM!F275","v":0},0]
["Advanced Application","Application I/O",null,"FTG18A-600R",{"$f":"VLOOKUP(D279,'AOMS List Price'!A$2:B$243,2, FALSE)","v":37.380000000000003},{"$f":"BOM!F276","v":0},0]
["Lighting System","Lighting Controller",null,"LC-VAC1001-0",{"$f":"VLOOKUP(D280,'AOMS List Price'!A$2:B$243,2, FALSE)","v":665.3},{"$f":"BOM!F277","v":0},0]
["Lighting System","Lighting Sensor",null,"MK7-B-CR-VTI",{"$f":"VLOOKUP(D281,'AOMS List Price'!A$2:B$243,2, FALSE)","v":551.61},{"$f":"BOM!F278","v":0},0]
["Lighting System","Lighting Sensor",null,"MK7-B-CCF-VTI",{"$f":"VLOOKUP(D282,'AOMS List Price'!A$2:B$243,2, FALSE)","v":673.38},{"$f":"BOM!F279","v":0},0]
["Lighting System","Lighting Sensor",null,"OLS-2100-1",{"$f":"VLOOKUP(D283,'AOMS List Price'!A$2:B$243,2, FALSE)","v":367.69},{"$f":"BOM!F280","v":0},0]
["Lighting System","Lighting Sensor",null,"RIBU1C",{"$f":"VLOOKUP(D284,'AOMS List Price'!A$2:B$243,2, FALSE)","v":30.52},{"$f":"BOM!F281","v":0},0]

{"sheet":"Learning Videos","index":17,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"System","Device(s)","Video Description (Click the Titles!)","Should You Watch?"]
[null,"Network","Smart Building Hub","Smart Building Hub Hardware SBH200",{"$f":"IF(BOM!F$13=1,\"Yes\",\"No\")","v":"No"}]
[null,"Network","Smart Building Hub","How to set Schedules in Verasys",{"$f":"IF(BOM!F$13=1,\"Yes\",\"No\")","v":"No"}]
[null,"Network","Smart Building Hub","How to setup new users and setup email and texting",{"$f":"IF(BOM!F$13=1,\"Yes\",\"No\")","v":"No"}]
[null,"Network","Smart Building Hub","Smart building Hub Alarm Notification",{"$f":"IF(BOM!F$13=1,\"Yes\",\"No\")","v":"No"}]
[null,"Network","Smart Building Hub","How to setup Smart Building hub ethernet and internet settings",{"$f":"IF(BOM!F$13=1,\"Yes\",\"No\")","v":"No"}]
[null,"Network","Smart Building Hub","How to upgrade software on the Smart Building Hub",{"$f":"IF(BOM!F$13=1,\"Yes\",\"No\")","v":"No"}]
[null,"Network","Smart Building Hub","Smart Building Audit Log",{"$f":"IF(BOM!F$13=1,\"Yes\",\"No\")","v":"No"}]
[null,"SZ- Single Zone","Smart Equipment","Smart Equipment Hardware and Network Setup",{"$f":"IF(SUM(BOM!F69:F81)>0,\"Yes\",\"No\")","v":"No"}]
[null,"SZ- Single Zone","Smart Equipment","Smart Equipment Setup in Verasys",{"$f":"IF(SUM(BOM!F70:F82)>0,\"Yes\",\"No\")","v":"No"}]
[null,"SZ- Single Zone","Smart Equipment","Smart Equipment Unit Setup for Net Sensors",{"$f":"IF(SUM(BOM!F71:F83)>0,\"Yes\",\"No\")","v":"No"}]
[null,"SZ - Single Zone","TEC Thermostat","TEC3000 Hardware and Network Setup",{"$f":"IF(SUM(BOM!F82:F99)>0,\"Yes\",\"No\")","v":"No"}]
[null,"MZ- COBP or VAV","Zone Coordinator","Zone Coordinator Hardware",{"$f":"IF(SUM(BOM!F$100:F$101)>0,\"Yes\",\"No\")","v":"No"}]
[null,"MZ- COBP","Zone Coordinator","How to setup a Zone Coordinator for Change over bypass",{"$f":"IF(OR(BOM!F177>0,SUM(BOM!F191:F203)>0),\"Yes\",\"No\")","v":"No"}]
[null,"MZ- VAV","Zone Coordinator","How to setup a Zone Coordinator for VAV",{"$f":"IF(AND(SUM(BOM!F$119:F$121)>0,SUM(BOM!F$161:F$173)=0,BOM!F$146=0),\"Yes\",\"No\")","v":"No"}]
[null,"MZ- COBP","Zone COBP Controllers","Zone Controller and Bypass Controller Hardware",{"$f":"IF(OR(BOM!F177>0,SUM(BOM!F191:F203)>0),\"Yes\",\"No\")","v":"No"}]
[null,"MZ- COBP","Zone COBP Controllers","How to setup a ZEC310 zone controller",{"$f":"IF(OR(BOM!F177>0,SUM(BOM!F191:F203)>0),\"Yes\",\"No\")","v":"No"}]
[null,"MZ- COBP or VAV","VAV Box Controllers","ZEC410 Controller Setup through Verasys",{"$f":"IF(SUM(BOM!F$119:F$121)>0,\"Yes\",\"No\")","v":"No"}]
[null,"MZ- COBP or VAV","Smart Equipment","Smart Equipment Setup in Verasys",{"$f":"IF(SUM(BOM!F$100:F$101)>BOM!F$107,\"Maybe\",\"No\")","v":"No"}]
[null,"MZ- COBP or VAV","3rd Party Equipment","VEC100 Controller Hardware and Network Setup",{"$f":"IF(BOM!F$107>0,\"Yes\",\"No\")","v":"No"}]
[null,"MZ- COBP or VAV","3rd Party Equipment","VEC100 Controller Setup through Verasys",{"$f":"IF(BOM!F$107>0,\"Yes\",\"No\")","v":"No"}]
[null,"IOM Device","VAC Controller","VAC Controller Family Hardware",{"$f":"IF(AND(BOM!F$23>0,SUM(BOM!F$247:F$248)>0),\"Yes\",\"No\")","v":"No"}]
[null,"IOM Device","IOM Device","VAC1002 Input Output Configuration",{"$f":"IF(AND(BOM!F$23>0,SUM(BOM!F$247:F$248)>0),\"Yes\",\"No\")","v":"No"}]
[null,"IOM Device","Wireless NS","VAC1002 Connecting to Wireless One to One Sensors",{"$f":"IF(BOM!F$60>0,\"Yes\",\"No\")","v":"No"}]
[null,"IOM Device","Energy Meter","VAC1002 Connecting to an Energy Meter",{"$f":"IF(SUM(BOM!F$66:F$68)>0,\"Yes\",\"No\")","v":"No"}]
[null,"Lighting","VAC Controller","VAC Controller Family Hardware",{"$f":"IF(AND(BOM!F$23>0,SUM(BOM!F$247:F$248)>0),\"Yes\",\"No\")","v":"No"}]
[null,"Lighting","Lighting Controller","VAC1001 Lighting Controller Configuration",{"$f":"IF(BOM!F$277>0,\"Yes\",\"No\")","v":"No"}]
[null,"Wireless","Wireless ZFR","Verasys Wireless Pro System Layout-Estimating",{"$f":"IF(SUM(BOM!F$90:F$92)>0,\"Yes\",\"No\")","v":"No"}]
[null,"Wireless","Wireless ZFR","Verasys Wireless Pro System Troubleshooting",{"$f":"IF(SUM(BOM!F$90:F$92)>0,\"Yes\",\"No\")","v":"No"}]

{"sheet":"Smart Building Hub Videos","index":18,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":true,"merged":[[6,1,12,1],[14,1,15,1]]}
[]
[]
[]
[]
[]
[null,"Audience","Video Description"]
[null,"Installers","How to setup new users and setup email and texting"]
[null,null,"How to setup Smart Building hub ethernet and internet settings"]
[null,null,"How to upgrade software on the Smart Building Hub"]
[null,null,"Smart Building Hub SBH200 Connecting for the First Time"]
[null,null,"Smart Building Hub Hardware SBH200"]
[null,null,"How to set Schedules in Verasys"]
[null,null,"Smart building Hub Alarm Notification"]
[]
[null,"Trouble Shooting","Smart building Hub Alarm Notification"]
[null,null,"Smart Building Hub SBH200 Factory Reset"]

{"sheet":"VAC100x Controllers Videos","index":19,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[[6,1,10,1]]}
[]
[]
[]
[]
[]
[null,"Audience","Video Description"]
[null,"Installers","VAC1002 Connecting to an Energy Meter"]
[null,null,"VAC Controller Family Hardware"]
[null,null,"VAC1002 Connecting to Wireless One to One Sensors"]
[null,null,"VAC1001 Lighting Controller Configuration"]
[null,null,"VAC1002 Input Output Configuration"]

{"sheet":"Energy Meters","index":20,"n_rows":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["SENVA-01-EMC-3N-03S-03","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 300A, 9 IN CIRCUM., 3FT LEAD "]
["SENVA-01-EMC-3N-03S-10","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 300A, 9 IN CIRCUM. 10FT LEAD "]
["SENVA-01-EMC-3N-08S-03","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 800A, 9 IN CIRCUM., 3FT LEAD "]
["SENVA-01-EMC-3N-08S-10","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 800A, 9 IN CIRCUM. 10FT LEAD "]
["SENVA-01-EMC-3N-08M-03","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 800A, 15IN CIRCUM., 3FT LEAD"]
["SENVA-01-EMC-3N-08M-10","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 800A, 15IN CIRCUM. 10FT LEAD"]
["SENVA-01-EMC-3N-15S-03","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 1500A, 9 IN CIRCUM., 3FT LEAD"]
["SENVA-01-EMC-3N-15S-10","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 1500A, 9 IN CIRCUM. 10FT LEAD"]
["SENVA-01-EMC-3N-15M-03","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 1500A, 15IN CIRCUM. 3FT LEAD"]
["SENVA-01-EMC-3N-15M-10","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 1500A, 15IN CIRCUM.10FT LEAD"]
["SENVA-01-EMC-3N-24M-03","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 2400A, 15IN CIRCUM. 3FT LEAD"]
["SENVA-01-EMC-3N-24M-10","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 2400A, 15IN CIRCUM.10FT LEAD"]
["SENVA-01-EMC-3N-24L-03","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 2400A, 24IN CIRCUM. 3FT LEAD"]
["SENVA-01-EMC-3N-24L-10","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 2400A, 24IN CIRCUM.10FT LEAD"]
["SENVA-01-EMC-3N-60G-03","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 6000A, 36IN CIRCUM. 3FT LEAD"]
["SENVA-01-EMC-3N-60G-10","ENERGY METER KIT, COMMS TYPE, 3 CVT, NO FUSE, 6000A, 36IN CIRCUM.10FT LEAD "]
["SENVA-01-EMC-2N-03S-03","ENERGY METER KIT, COMMS TYPE, 2 CVT, NO FUSE, 300A, 9 IN CIRCUM., 3FT LEAD "]
["SENVA-01-EMC-2N-03S-10","ENERGY METER KIT, COMMS TYPE, 2 CVT, NO FUSE, 300A, 9 IN CIRCUM., 10FT LEAD "]
["SENVA-01-EMC-2N-08S-03","ENERGY METER KIT, COMMS TYPE, 2 CVT, NO FUSE, 800A, 9 IN CIRCUM., 3FT LEAD "]
["SENVA-01-EMC-2N-08S-10","ENERGY METER KIT, COMMS TYPE, 2 CVT, NO FUSE, 800A, 9 IN CIRCUM., 10FT LEAD "]
["SENVA-01-EMC-2N-08M-03","ENERGY METER KIT, COMMS TYPE, 2 CVT, NO FUSE, 800A, 15IN CIRCUM., 3FT LEAD"]
["SENVA-01-EMC-2N-08M-10","ENERGY METER KIT, COMMS TYPE, 2 CVT, NO FUSE, 800A, 15IN CIRCUM. 10FT LEAD"]
["SENVA-01-EMC-2N-15S-03","INVALID PART NUMBER - CVT AMP Exceeds 800 Amps"]
["SENVA-01-EMC-2N-15S-10","INVALID PART NUMBER - CVT AMP Exceeds 800 Amps"]
["SENVA-01-EMC-2N-15M-03","INVALID PART NUMBER - CVT AMP Exceeds 800 Amps"]
["SENVA-01-EMC-2N-15M-10","INVALID PART NUMBER - CVT AMP Exceeds 800 Amps"]
["SENVA-01-EMC-2N-24M-03","INVALID PART NUMBER - CVT AMP Exceeds 800 Amps"]
["SENVA-01-EMC-2N-24M-10","INVALID PART NUMBER - CVT AMP Exceeds 800 Amps"]
["SENVA-01-EMC-2N-24L-03","INVALID PART NUMBER - CVT AMP Exceeds 800 Amps"]
["SENVA-01-EMC-2N-24L-10","INVALID PART NUMBER - CVT AMP Exceeds 800 Amps"]
["SENVA-01-EMC-2N-60G-03","INVALID PART NUMBER - CVT AMP Exceeds 800 Amps"]
["SENVA-01-EMC-2N-60G-10","INVALID PART NUMBER - CVT AMP Exceeds 800 Amps"]
["SENVA-01-EMC-3N-3S-03","INVALID PART NUMBER - CVT AMP INPUT WRONG!!!"]
["SENVA-01-EMC-3N-3S-10","INVALID PART NUMBER - CVT AMP INPUT WRONG!!!"]
["SENVA-01-EMC-3N-8S-03","INVALID PART NUMBER - CVT AMP INPUT WRONG!!!"]
["SENVA-01-EMC-3N-8S-10","INVALID PART NUMBER - CVT AMP INPUT WRONG!!!"]
["SENVA-01-EMC-3N-8M-03","INVALID PART NUMBER - CVT AMP INPUT WRONG!!!"]
["SENVA-01-EMC-3N-8M-10","INVALID PART NUMBER - CVT AMP INPUT WRONG!!!"]

{"sheet":"AOMS List Price","index":21,"n_rows":243,"n_cols":2,"rows_kept":243,"cut":false,"hidden":true,"merged":[]}
["JCI Part Number","AOMS List Price"]
["RCG18B",341.60180000000003]
["RCG17B",320.53480000000002]
["RCG16B",269.077]
["RCG15B",259.7088]
["RCG14B",255.047]
["RCG13B",238.64179999999999]
["RCG12B",226.9427]
["RCG11B",219.95]
["RCG10B",208.20590000000001]
["RCG09B",205.92]
["RCG08B",201.2139]
["RCG07B",196.55179999999999]
["RCG06B",191.8458]
["RCG04B",189.51480000000001]
["LC-VAC3000-0","N/A"]
["LC-SBH200-0",1853.49]
["LC-VAC1000-0",665.3]
["LC-VAC1001-0",665.3]
["LC-VAC1002-0",665.3]
["LC-ZFR1825-0",470.06]
["LC-ZFR1822-0B",222.42]
["LC-ZFR1821-0B",205.35]
["EMC-3N-03S-03",1958.955223880597]
["EMC-3N-03S-10",2212.1125143513204]
["EMC-3N-08S-03",1958.955223880597]
["EMC-3N-08S-10",2212.1125143513204]
["EMC-3N-08M-03",2175.947187141217]
["EMC-3N-08M-10",2429.1044776119406]
["EMC-3N-15S-03",1958.955223880597]
["EMC-3N-15S-10",2212.1125143513204]
["EMC-3N-15M-03",2175.947187141217]
["EMC-3N-15M-10",2429.1044776119406]
["EMC-3N-24M-03",2175.947187141217]
["EMC-3N-24M-10",2429.1044776119406]
["EMC-3N-24L-03",2483.3524684270956]
["EMC-3N-24L-10",2754.5924225028702]
["EMC-3N-60G-03",2881.1710677382321]
["EMC-3N-60G-10",3152.4110218140072]
["EMC-2N-03S-03",1506.8886337543056]
["EMC-2N-03S-10",1675.660160734788]
["EMC-2N-08S-03",1506.8886337543056]
["EMC-2N-08S-10",1675.660160734788]
["EMC-2N-08M-03",1651.5499425947187]
["EMC-2N-08M-10",1820.3214695752013]
["RLD-134A",2260.52]
["WRZ-STR0000-0",923.02]
["WD-2-T-25",839.6]
["WRZ-RMT10K-0",778.9]
["WD-2-T-10",543.79999999999995]
["WRZ-THN0000-0",410.04]
["DPT2090-25G",356]
["DPT2640-0R1B",333.24]
["DPT2640-R25D",333.24]
["WRZ-7860-0",237.68]
["WD-1B",231.6]
["CSDSC-C50100L1",185.77]
["CSDECM-C35200L1",150.99]
["A-306-K",119.68]
["CSDSC-C50100L0",116.2]
["SD-01",101.85]
["CSDECM-C35200L0",81.41]
["ZFR-CBLEXT-0",77.73]
["TBG16A-600R",50.51]
["RPS",39.92]
["RPS-W",27.88]
["TEC3023-00-000",899.98]
["TEC3023-01-000",899.98]
["4683-TTM-3F",872.96]
["TEC3012-00-000",842.07]
["TEC3012-01-000",842.07]
["TEC3013-00-000",823.72]
["TEC3013-01-000",823.72]
["TEC3022-00-000",820.41]
["TEC3022-01-000",820.41]
["TEC3021-00-000",813.34]
["TEC3021-01-000",813.34]
["TEC3031-00-000",761.22]
["TEC3031-01-000",761.22]
["TEC3011-00-000",737.08]
["TEC3011-01-000",737.08]
["TEC3020-00-000",716.98]
["TEC3020-01-000",716.98]
["TEC3010-00-000",661.12]
["TEC3010-01-000",661.12]
["TEC3030-00-000",592.44000000000005]
["TEC3030-01-000",592.44000000000005]
["NS-BTK7002-0",206]
["NS-BTK7002-2",206]
["MS-BACEOL-0",115.21]
["HE-68P3-0N000",1378.11]
["CD-P1000-00-00",1158.92]
["NS-BCN7004-0",1156.49]
["LC-VZCPNL-0",1139.8900000000001]
["RZV17Z",979.7]
["RZV18Z",979.7]
["RZV17Y",954.79]
["RZV18Y",954.79]
["UPSPNL550-0",930.32]
["TEC3623-00-000",899.98]
["TEC3623-01-000",899.98]
["RZV15Z",880.1]
["RZV16Z",880.1]
["RZV13Z",860.86]
["RZV14Z",860.86]
["RZV15Y",855.25]
["RZV16Y",855.25]
["RZV13Y",835.96]
["RZV14Y",835.96]
["TEC3613-00-000",823.72]
["TEC3613-01-000",823.72]
["RZV11Z",822.32]
["RZV12Z",822.32]
["TEC3622-00-000",820.41]
["TEC3622-01-000",820.41]
["TEC3621-00-000",813.34]
["TEC3621-01-000",813.34]
["PSH500A",799.4]
["RZV11Y",797.42]
["RZV12Y",797.42]
["RZV09Z",796.62]
["RZV10Z",796.62]
["RZV07Z",786.97]
["RZV08Z",786.97]
["RZV06Z",774.14]
["RZV09Y",771.72]
["RZV10Y",771.72]
["RZV07Y",762.07]
["RZV08Y",762.07]
["TEC3631-00-000",761.22]
["TEC3631-01-000",761.22]
["RZV06Y",749.24]
["TEC3612-00-000",744.15]
["TEC3612-01-000",744.15]
["TEC3620-00-000",737.38]
["TEC3620-01-000",737.38]
["TEC3611-00-000",737.08]
["TEC3611-01-000",737.08]
["NS-BHP7003-0",710.15]
["LC-VEC100-0",698.56]
["NS-BHR7103-0",693.51]
["NS-BHM7103-2",693.19]
["TEC3630-00-000",685.26]
["TEC3630-01-000",685.26]
["MK7-B-CCF-VTI",673.38]
["TEC3610-00-000",661.12]
["TEC3610-01-000",661.12]
["LC-BYP200-0",604.27]
["PSH300A",592.04]
["LC-VZC100-0",590.79999999999995]
["LC-ZEC410-1",583.73]
["LC-ZEC410-2",583.73]
["LC-ZEC410-3",583.73]
["LC-ZEC310-0",564.74]
["MK7-B-CR-VTI",551.61]
["NS-BHP7001-0",539.24]
["HE-68N3-0N00WS",523.74]
["NS-BHN7003-0",515.21]
["CD-W00-00-2",515]
["M9208-GGA-3",493.34]
["HE-67N3-0N00P",469.4]
["A70HA-1C",376.93]
["OLS-2100-1",367.69]
["M9310-HGA-2",366.24]
["DPT2640-005D",333.24]
["WRZ-TTR0000-0",267.77999999999997]
["NS-ATV7003-0",245.07]
["NS-BTB7F03-0",227.93]
["NS-BTJ7002-0",190.55]
["NS-BTJ7002-2",190.55]
["NS-BTB7003-0",189.94]
["NS-BTB7003-2",189.94]
["ACC-WIFIKIT-ODU",178.68]
["SE-COM1001-0",177.79]
["PSH100A",173.2]
["P32AC-2C",159.03]
["TE-6315M-1",158.72]
["NS-BTP7002-0",156.21]
["NS-BTP7002-2",156.21]
["ACC-PWRKIT-1A24",154.36000000000001]
["NS-BTN7001-0",148.51]
["NS-BTN7001-2",148.51]
["NS-BTN7003-0",147.05000000000001]
["NS-BTN7003-2",147.05000000000001]
["M9208-250",131.12]
["TE-68NT-1N00S",107.01]
["TE-68NT-0N00S",95.95]
["2505A",91.37]
["CSD-CF0A0-1",84.07]
["Y65T42-0",76.63]
["TE-6313P-1",51.47]
["FTG18A-600R",37.380000000000003]
["TE-6311M-1",35.630000000000003]
["TE-631GV-2",35.61]
["RIBU1C",30.52]
["TE-6001-8",12.62]
["TEC-WALLPLT",10.71]
["2020-T",9.39]
["CBL-22/3-FC-PVC ",0.36]
["CBL-22/3-FC-PLN",0.3]
["CBL-22/2P-SAPLN",0.68]
["CBL-22/2P-SAPVC",0.56000000000000005]
["NS-BHN7003-0",678.51]
["RZG06B",122.87]
["RZG07B",132.35]
["RZG08B",132.35]
["RZG09B",139.4]
["RZG10B",139.4]
["RZG11B",158.32]
["RZG12B",158.32]
["RZG13B",186.66]
["RZG14B",186.66]
["RZG15B",200.86]
["RZG16B",200.86]
["RZG17B",274.13]
["RZG18B",274.13]
["CSDECM-C35200L0",107.21]
["MK7-B-CR-VTI",726.44]
["SENVA-01-EMC-3N-03S-03",1958.955223880597]
["SENVA-01-EMC-3N-03S-10",2212.1125143513204]
["SENVA-01-EMC-3N-08S-03",1958.955223880597]
["SENVA-01-EMC-3N-08S-10",2212.1125143513204]
["SENVA-01-EMC-3N-08M-03",2175.947187141217]
["SENVA-01-EMC-3N-08M-10",2429.1044776119406]
["SENVA-01-EMC-3N-15S-03",1958.955223880597]
["SENVA-01-EMC-3N-15S-10",2212.1125143513204]
["SENVA-01-EMC-3N-15M-03",2175.947187141217]
["SENVA-01-EMC-3N-15M-10",2429.1044776119406]
["SENVA-01-EMC-3N-24M-03",2175.947187141217]
["SENVA-01-EMC-3N-24M-10",2429.1044776119406]
["SENVA-01-EMC-3N-24L-03",2483.3524684270956]
["SENVA-01-EMC-3N-24L-10",2754.5924225028702]
["SENVA-01-EMC-3N-60G-03",2881.1710677382321]
["SENVA-01-EMC-3N-60G-10",3152.4110218140072]
["SENVA-01-EMC-2N-03S-03",1506.8886337543056]
["SENVA-01-EMC-2N-03S-10",1675.660160734788]
["SENVA-01-EMC-2N-08S-03",1506.8886337543056]
["SENVA-01-EMC-2N-08S-10",1675.660160734788]
["SENVA-01-EMC-2N-08M-03",1651.5499425947187]
["SENVA-01-EMC-2N-08M-10",1820.3214695752013]
["PA0000004GC0",773.22]
["PA0000001AH0",806.43]
["PA0000001EH0",879.77]

{"sheet":"Source 1 Parts Ref","index":22,"n_rows":239,"n_cols":9,"rows_kept":239,"cut":false,"hidden":true,"merged":[]}
["JCI Part No","Source 1 Part No"]
["LC-SBH100-1","S1-LC-SBH100-1"]
["LC-IOM100-0","S1-LC-IOM100-0"]
["Y65T42-0","S1-Y65T42-0"]
["TE-68NT-0N00S","S1-TE68NT1N00S"]
["TE-6311M-1","S1-TE-6311M-1"]
["TE-6313P-1","S1-TE-6313P-1"]
["HE-68N3-0N00WS","S1-H68N30N00WS"]
["HE-68P3-0N000","S1-H68P30N000"]
["HE-67N3-0N00P","S1-H67N30N00P"]
["CD-W00-00-2","S1-CDW-00-00-2"]
["NS-BTB7003-0","S1-NSBTB7003-0"]
["NS-BTB7003-2","S1-NSBTB7003-2"]
["NS-BTN7003-0","S1-NSBTN7003-0"]
["NS-BTN7003-2","S1-NSBTN7003-2"]
["NS-BTP7002-0","S1-NSBTP7002-0"]
["NS-BTP7002-2","S1-NSBTP7002-2"]
["NS-BHR7103-0","S1-NSBHR7103-0"]
["NS-BHP7001-0","S1-NSBHP7001-0"]
["NS-BTB7F03-0","S1-NSBTB7F03-0"]
["NS-BCN7004-0","S1-NSBCN7004-0"]
["TEC3630-00-000","S1-TEC3630-00"]
["TEC3631-00-000","S1-TEC3631-00"]
["TEC3630-01-000","S1-TEC3630-01"]
["TEC3631-01-000","S1-TEC3631-01"]
["TE-6311M-1","S1-TE-6311M-1"]
["TE-6313P-1","S1-TE-6313P-1"]
["TE-68NT-0N00S","S1-T68NT0N00S"]
["TEC-WALLPLT","S1-TEC-WALLPLT"]
["CSD-CF0A0-1","S1-CSD-CF0A0-1"]
["M9208-GGA-3","S1-M9106-GGA-2"]
["M9208-250","S1-M9208-250"]
["LC-VZC100-0","S1-LC-VZC100-0"]
["LC-VZCPNL-0","S1-LC-VZCPNL-0"]
["Y65T42-0","S1-Y65T42-0"]
["PSH100A","S1-PSH100A"]
["PSH300A","S1-PSH300A"]
["PSH500A","S1-PSH500A"]
["LC-VEC100-0","S1-LC-VEC100-0"]
["TE-6311M-1","S1-TE-6311M-1"]
["DPT2640-005D","S1-DPT2640005D"]
["FTG18A-600R","S1-FTG18A-600R"]
["TE-6313P-1","S1-TE-6313P-1"]
["P32AC-2C","S1-P32AC-2C"]
["FTG18A-600R","S1-FTG18A-600R"]
["CSD-CF0A0-1","S1-CSD-CF0A0-1"]
["CD-P00-00-0"]
["NS-BHN7003-0","S1-NSBHN7003-0"]
["M9208-GGA-3","S1-M9106-GGA-2"]
["M9208-250","S1-M9208-250"]
["LC-ZEC410-1","S1-LC-ZEC410-1"]
["LC-ZEC410-2","S1-LC-ZEC410-2"]
["LC-ZEC410-3","S1-LC-ZEC410-3"]
["NS-BTB7003-0","S1-NSBTB7003-0"]
["NS-BTB7003-2","S1-NSBTB7003-2"]
["NS-BTN7003-0","S1-NSBTN7003-0"]
["NS-BTN7003-2","S1-NSBTN7003-2"]
["NS-BTP7002-0","S1-NSBTP7002-0"]
["NS-BTP7002-2","S1-NSBTP7002-2"]
["TE-631GV-2","S1-TE631GV-2"]
["NS-BCN7004-0","S1-NSBCN7004-0"]
["OLS-2100-1","S1-OLS-2100-1"]
["RIBU1C","S1-RIBU1C"]
["NS-ATV7003-0","S1-NSATV7003-0"]
["NS-BTB7003-0","S1-NSBTB7003-0"]
["NS-BTB7003-2","S1-NSBTB7003-2"]
["NS-BTN7003-0","S1-NSBTN7003-0"]
["NS-BTN7003-2","S1-NSBTN7003-2"]
["NS-BTP7002-0","S1-NSBTP7002-0"]
["NS-BTP7002-2","S1-NSBTP7002-2"]
["TE-68NT-0N00S","S1-T68NT0N00S"]
["TE-68NT-1N00S","S1-TE68NT1N00S"]
["NS-BCN7004-0","S1-M9106-GGA-2"]
["LC-ZEC310-0","S1-LC-ZEC310-0"]
["RZG06B","S1-RZG06B"]
["RZG07B","S1-RZG07B"]
["RZG08B","S1-RZG08B"]
["RZG09B","S1-RZG09B"]
["RZG10B","S1-RZG10B"]
["RZG11B","S1-RZG11B"]
["RZG12B","S1-RZG12B"]
["RZG13B","S1-RZG13B"]
["RZG14B","S1-RZG14B"]
["RZG15B","S1-RZG15B"]
["RZG16B","S1-RZG16B"]
["RZG17B","S1-RZG17B"]
["RZG18B","S1-RZG18B"]
["RZV06Z","S1-RZV06Z"]
["RZV07Z","S1-RZV07Z"]
["RZV08Z","S1-RZV08Z"]
["RZV09Z","S1-RZV09Z"]
["RZV10Z","S1-RZV10Z"]
["RZV11Z","S1-RZV11Z"]
["RZV12Z","S1-RZV12Z"]
["RZV13Z","S1-RZV13Z"]
["RZV14Z","S1-RZV14Z"]
["RZV15Z","S1-RZV15Z"]
["RZV16Z","S1-RZV16Z"]
["RZV17Z","S1-RZV17Z"]
["RZV18Z","S1-RZV18Z"]
["OLS-2100-1","S1-OLS-2100-1"]
["RIBU1C","S1-RIBU1C"]
["M9106-GGA-2","S1-M9106-GGA-2"]
["LC-BYP200-0","S1-LC-BYP200-0"]
["RZG06B","S1-RZG06B"]
["RZG07B","S1-RZG07B"]
["RZG08B","S1-RZG08B"]
["RZG09B","S1-RZG09B"]
["RZG10B","S1-RZG10B"]
["RZG11B","S1-RZG11B"]
["RZG12B","S1-RZG12B"]
["RZG13B","S1-RZG13B"]
["RZG14B","S1-RZG14B"]
["RZG15B","S1-RZG15B"]
["RZG16B","S1-RZG16B"]
["RZG17B","S1-RZG17B"]
["RZG18B","S1-RZG18B"]
["RZV06Y","S1-RZV06Y"]
["RZV07Y","S1-RZV07Y"]
["RZV08Y","S1-RZV08Y"]
["RZV09Y","S1-RZV09Y"]
["RZV10Y","S1-RZV10Y"]
["RZV11Y","S1-RZV11Y"]
["RZV12Y","S1-RZV12Y"]
["RZV13Y","S1-RZV13Y"]
["RZV14Y","S1-RZV14Y"]
["RZV15Y","S1-RZV15Y"]
["RZV16Y","S1-RZV16Y"]
["RZV17Y","S1-RZV17Y"]
["RZV18Y","S1-RZV18Y"]
["DPT2640-005D","S1-DPT2640005D"]
["FTG18A-600R","S1-FTG18A-600R"]
["Y65T42-0","S1-Y65T42-0"]
["M9106-GGA-2","S1-M9106-GGA-2"]
["TEC3610-00-000","S1-TEC3610-00"]
["TEC3611-00-000","S1-TEC3611-00"]
["TEC3612-00-000","S1-TEC3612-00"]
["TEC3613-00-000","S1-TEC3613-00"]
["TEC3620-00-000","S1-TEC3620-00"]
["TEC3621-00-000","S1-TEC3621-00"]
["TEC3622-00-000","S1-TEC3622-00"]
["TEC3623-00-000","S1-TEC3623-00"]
["TEC3610-01-000","S1-TEC3610-01"]
["TEC3611-01-000","S1-TEC3611-01"]
["TEC3612-01-000","S1-TEC3612-01"]
["TEC3613-01-000","S1-TEC3613-01"]
["TEC3620-01-000","S1-TEC3620-01"]
["TEC3621-01-000","S1-TEC3621-01"]
["TEC3622-01-000","S1-TEC3622-01"]
["TEC3623-01-000","S1-TEC3623-01"]
["TE-6311M-1","S1-TE-6311M-1"]
["TE-68NT-0N00S","S1-TE68NT1N00S"]
["CSD-CF0A0-1","S1-CSD-CF0A0-1"]
["TEC-WALLPLT","S1-TEC-WALLPLT"]
["LC-VAC1000-0","S1-LCVAC1000-0"]
["LC-VAC1001-0","S1-LCVAC1001-0"]
["LC-VAC1002-0","S1-LCVAC1002-0"]
["LC-VAC1100-0","S1-LCVAC1100-0"]
["LC-VAC3000-0","S1-LCVAC3000-0"]
["LC-VLP100-0","S1-LC-VLP100-0"]
["LC-VLP110-0","S1-LC-VLP110-0"]
["LC-VLP120-0","S1-LC-VLP120-0"]
["LC-IOP200-0","S1-LC-IOP200-0"]
["LC-SBH200-0","S1-LC-SBH200-0"]
["LC-ZFR1825-0","S1-LCZFR1825-0"]
["LC-ZFR1822-0","S1-LCZFR1822-0"]
["LC-ZFR1822-0B","S1-LCZFR18220B"]
["LC-ZFR1821-0","S1-LCZFR1821-0"]
["LC-ZFR1821-0B","S1-LCZFR18210B"]
["DPT2090-25G","S1-DPT2090-25G"]
["TBG16A-600R","S1-TBG16A-600R"]
["DPT2640-0R1B","S1-DPT26400R1B"]
["DPT2640-R25D","S1-DPT2640R25D"]
["A-306-K","S1-A-306-K"]
["SD-01","S1-SD-01"]
["RPS","S1-RPS"]
["RPS-W","S1-RPS-W"]
["RLD-134A","S1-RLD-134A"]
["WD-1B","S1-WD-1B"]
["WD-2-T-10","S1-WD-2-T-10"]
["WD-2-T-25","S1-WD-2-T-25"]
["CSDSC-C50100L0","S1-CSDSCC50100L0"]
["CSDSC-C50100L1","S1-CSDSCC50100L1"]
["CSDECM-C35200L0","S1-CSDECMC35200L0"]
["CSDECM-C35200L1","S1-CSDECMC35200L1"]
["WRZ-7860-0","S1-WRZ-7860-0"]
["ZFR-CBLEXT-0","S1-ZFRCBLEXT-0"]
["WRZ-STR0000-0","S1-WRZSTR00000"]
["WRZ-RMT10K-0","S1-WRZRMT10K-0"]
["WRS-TTR0000-0","S1-WRSTTR00000"]
["WRZ-THN0000-0","S1-WRZTHN00000"]
["EMC-03N-03S-03","S1-EMC03N03S03",null,null,null,null,null,"EMC-03N-03S-03","Energy Meter 3 phase 300 amp 3 ft leads 9in ring"]
["EMC-03N-08S-03","S1-EMC03N08S03",null,null,null,null,null,"EMC-03N-08S-03","Energy Meter 3 phase 800 amp 3 ft leads 9in ring"]
["EMC-03N-08M-03","S1-EMC03N08M03",null,null,null,null,null,"EMC-03N-08M-03","Energy Meter 3 phase 800 amp 3 ft leads 15in ring"]
["EMC-03N-15S-03","S1-EMC03N15S03",null,null,null,null,null,"EMC-03N-15S-03","Energy Meter 3 phase 1500 amp 3 ft leads 9in ring"]
["EMC-03N-15M-03","S1-EMC03N15M03",null,null,null,null,null,"EMC-03N-15M-03","Energy Meter 3 phase 1500 amp 3 ft leads 15in ring"]
["EMC-03N-24M-03","S1-EMC03N24M03",null,null,null,null,null,"EMC-03N-24M-03","Energy Meter 3 phase 2400 amp 3 ft leads 15in ring"]
["EMC-03N-24M-03","S1-EMC03N24M03",null,null,null,null,null,"EMC-03N-24M-03","Energy Meter 3 phase 2400 amp 3 ft leads 24in ring"]
["EMC-03N-60G-03","S1-EMC03N60G03",null,null,null,null,null,"EMC-03N-60G-03","Energy Meter 3 phase 6000 amp 3 ft leads 36in ring"]
["EMC-02N-03S-03","S1-EMC02N03S03",null,null,null,null,null,"EMC-02N-03S-03","Energy Meter 2 phase 300 amp 3 ft leads 9in ring"]
["EMC-02N-08S-03","S1-EMC02N08S03",null,null,null,null,null,"EMC-02N-08S-03","Energy Meter 2 phase 800 amp 3 ft leads 9in ring"]
["EMC-02N-08M-03","S1-EMC02N08M03",null,null,null,null,null,"EMC-02N-08M-03","Energy Meter 2 phase 800 amp 3 ft leads 15in ring"]
["EMC-10N-10S-10","S1-EMC10N10S10",null,null,null,null,null,"EMC-10N-10S-10","Energy Meter 3 phase 300 amp 10 ft leads 9in ring"]
["EMC-10N-08S-10","S1-EMC10N08S10",null,null,null,null,null,"EMC-10N-08S-10","Energy Meter 3 phase 800 amp 10 ft leads 9in ring"]
["EMC-10N-08M-10","S1-EMC10N08M10",null,null,null,null,null,"EMC-10N-08M-10","Energy Meter 3 phase 800 amp 10 ft leads 15in ring"]
["EMC-10N-15S-10","S1-EMC10N15S10",null,null,null,null,null,"EMC-10N-15S-10","Energy Meter 3 phase 1500 amp 10 ft leads 9in ring"]
["EMC-10N-15M-10","S1-EMC10N15M10",null,null,null,null,null,"EMC-10N-15M-10","Energy Meter 3 phase 1500 amp 10 ft leads 15in ring"]
["EMC-10N-24M-10","S1-EMC10N24M10",null,null,null,null,null,"EMC-10N-24M-10","Energy Meter 3 phase 2400 amp 10 ft leads 15in ring"]
["EMC-10N-24M-10","S1-EMC10N24M10",null,null,null,null,null,"EMC-10N-24M-10","Energy Meter 3 phase 2400 amp 10 ft leads 24in ring"]
["EMC-10N-24G-10","S1-EMC10N24G10",null,null,null,null,null,"EMC-10N-24G-10","Energy Meter 3 phase 6000 amp 10 ft leads 36in ring"]
["EMC-02N-10S-10","S1-EMC02N10S10",null,null,null,null,null,"EMC-02N-10S-10","Energy Meter 2 phase 300 amp 10 ft leads 9in ring"]
["EMC-02N-08S-10","S1-EMC02N08S10",null,null,null,null,null,"EMC-02N-08S-10","Energy Meter 2 phase 800 amp 10 ft leads 9in ring"]
["EMC-02N-08M-10","S1-EMC02N08M10",null,null,null,null,null,"EMC-02N-08M-10","Energy Meter 2 phase 800 amp 10 ft leads 15in ring"]
["ROGFUSE-KIT","S1-ROGFUSE-KIT"]
["TEC3010-00-000","S1-TEC30100000"]
["TEC3011-00-000","S1-TEC30110000"]
["TEC3012-00-000","S1-TEC30120000"]
["TEC3013-00-000","S1-TEC30130000"]
["TEC3020-00-000","S1-TEC30200000"]
["TEC3021-00-000","S1-TEC30210000"]
["TEC3022-00-000","S1-TEC30220000"]
["TEC3023-00-000","S1-TEC30230000"]
["TEC3030-00-000","S1-TEC30300000"]
["TEC3031-00-000","S1-TEC30310000"]
["TEC3010-01-000","S1-TEC30100100"]
["TEC3011-01-000","S1-TEC30110100"]
["TEC3012-01-000","S1-TEC30120100"]
["TEC3013-01-000","S1-TEC30130100"]
["TEC3020-01-000","S1-TEC30200100"]
["TEC3021-01-000","S1-TEC30210100"]
["TEC3022-01-000","S1-TEC30220100"]
["TEC3023-01-000","S1-TEC30230100"]
["TEC3030-01-000","S1-TEC30300100"]
["TEC3031-01-000","S1-TEC30310100"]
["M9310-HGA-2 ","S1-M9310HGA-2 "]
["MS-BACEOL-0","S1-MS-BACEOL-0"]
["4683-TTM-3F","S1-4683-TTM-3F"]
["NS-BTK7002-0","S1-NSBTK7002-0"]
["NS-BTK7002-2","S1-NSBTK7002-2"]